BIP – Extract Grade Ladder, Grade and Step details

Below query can be used to extract grade ladder, grades in ladder and step details of a grade.

SELECT pglftl.name  		grade_ladder_name
     , pglf.grade_type		grade_type
     , pglf.active_status	active_status
     , pgftl.name			grade_name
     , pgilf.sequence		grade_seq_in_ladder
	 , pgsf.sequence		grade_step_seq 
	 , pgsftl.name			grade_step_name
  FROM PER_GRADE_LADDERS_F pglf
     , PER_GRADE_LADDERS_F_TL pglftl
	 , PER_GRADES_IN_LADDERS_F pgilf  
	 , PER_GRADES_F_TL pgftl 
     , PER_GRADE_STEPS_F pgsf	 
     , PER_GRADE_STEPS_F_TL pgsftl
WHERE pglf.grade_ladder_id = pglftl.grade_ladder_id
  AND TRUNC(SYSDATE) BETWEEN TRUNC(pglf.effective_start_date) AND TRUNC(pglf.effective_end_date)
  AND pglftl.language='US'
  AND TRUNC(SYSDATE) BETWEEN TRUNC(pglftl.effective_start_date) AND TRUNC(pglftl.effective_end_date)
  AND pgilf.grade_ladder_id = pglftl.grade_ladder_id
  AND TRUNC(SYSDATE) BETWEEN TRUNC(pgilf.effective_start_date) AND TRUNC(pgilf.effective_end_date) 
  AND pgftl.language='US'  
  AND TRUNC(SYSDATE) BETWEEN TRUNC(pgftl.effective_start_date) AND TRUNC(pgftl.effective_end_date)
  AND pgilf.grade_id = pgftl.grade_id
  AND pgsf.grade_id = pgftl.grade_id
  AND TRUNC(SYSDATE) BETWEEN TRUNC(pgsf.effective_start_date) AND TRUNC(pgsf.effective_end_date)
  AND pgsftl.grade_step_id = pgsf.grade_step_id
  AND pgsftl.language='US' 
  AND trunc(sysdate) between trunc(pgsftl.effective_start_date) and trunc(pgsftl.effective_end_date)