VIEW: APPS.PQH_CORPS_DEFINITIONS_V

Source

View Text - Preformatted

SELECT cpd.corps_definition_id corps_definition_id, cpd.object_version_number object_version_number, cpd.business_group_id business_group_id, cpd.name name, hr_general.decode_lookup('PQH_CORPS_STATUS',cpd.status_cd) status_desc, cpd.status_cd status_cd, cpd.retirement_age retirement_age, hr_general.decode_lookup('PQH_CORPS_CATEGORY',cpd.category_cd) category_desc, cpd.category_cd category_cd, grt.name starting_grade, spt.spinal_point starting_step, psp.name scale, grt.grade_id starting_grade_id, cpd.starting_grade_step_id starting_grade_step_id, hr_general.decode_lookup('FR_PQH_ORG_CATEGORY',cpd.nature_type_cd) nature_type_desc, cpd.nature_type_cd nature_type_cd, hr_general.decode_lookup('PQH_CORPS_TYPE',cpd.corps_type_cd) type_desc, cpd.corps_type_cd type_cd, cpd.task_desc tasks, cpd.secondment_threshold secondment_threshold, cpd.normal_hours normal_hours, cpd.normal_hours_frequency normal_hours_frequency, hr_general.decode_lookup('FREQUENCY',cpd.normal_hours_frequency) nor_frequency_desc, cpd.minimum_hours minimum_hours, cpd.minimum_hours_frequency minimum_hours_frequency, hr_general.decode_lookup('FREQUENCY',cpd.minimum_hours_frequency) min_frequency_desc, cpd.effective_start_date effective_start_date, cpd.effective_end_date effective_end_date, cpd.recruitment_end_date recruitment_end_date from pqh_corps_definitions cpd , per_grades_tl grt , per_grade_spines gsp , per_spinal_point_steps sps , per_spinal_points spt , per_parent_spines psp WHERE cpd.starting_grade_step_id = sps.step_id(+) and sps.grade_spine_id = gsp.grade_spine_id(+) and gsp.parent_spine_id = psp.parent_spine_id(+) and sps.spinal_point_id = spt.spinal_point_id(+) and gsp.grade_id = grt.grade_id(+) and grt.language = userenv('LANG')

View Text - HTML Formatted

SELECT CPD.CORPS_DEFINITION_ID CORPS_DEFINITION_ID
, CPD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CPD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CPD.NAME NAME
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_STATUS'
, CPD.STATUS_CD) STATUS_DESC
, CPD.STATUS_CD STATUS_CD
, CPD.RETIREMENT_AGE RETIREMENT_AGE
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_CATEGORY'
, CPD.CATEGORY_CD) CATEGORY_DESC
, CPD.CATEGORY_CD CATEGORY_CD
, GRT.NAME STARTING_GRADE
, SPT.SPINAL_POINT STARTING_STEP
, PSP.NAME SCALE
, GRT.GRADE_ID STARTING_GRADE_ID
, CPD.STARTING_GRADE_STEP_ID STARTING_GRADE_STEP_ID
, HR_GENERAL.DECODE_LOOKUP('FR_PQH_ORG_CATEGORY'
, CPD.NATURE_TYPE_CD) NATURE_TYPE_DESC
, CPD.NATURE_TYPE_CD NATURE_TYPE_CD
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_TYPE'
, CPD.CORPS_TYPE_CD) TYPE_DESC
, CPD.CORPS_TYPE_CD TYPE_CD
, CPD.TASK_DESC TASKS
, CPD.SECONDMENT_THRESHOLD SECONDMENT_THRESHOLD
, CPD.NORMAL_HOURS NORMAL_HOURS
, CPD.NORMAL_HOURS_FREQUENCY NORMAL_HOURS_FREQUENCY
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, CPD.NORMAL_HOURS_FREQUENCY) NOR_FREQUENCY_DESC
, CPD.MINIMUM_HOURS MINIMUM_HOURS
, CPD.MINIMUM_HOURS_FREQUENCY MINIMUM_HOURS_FREQUENCY
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, CPD.MINIMUM_HOURS_FREQUENCY) MIN_FREQUENCY_DESC
, CPD.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, CPD.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CPD.RECRUITMENT_END_DATE RECRUITMENT_END_DATE
FROM PQH_CORPS_DEFINITIONS CPD
, PER_GRADES_TL GRT
, PER_GRADE_SPINES GSP
, PER_SPINAL_POINT_STEPS SPS
, PER_SPINAL_POINTS SPT
, PER_PARENT_SPINES PSP
WHERE CPD.STARTING_GRADE_STEP_ID = SPS.STEP_ID(+)
AND SPS.GRADE_SPINE_ID = GSP.GRADE_SPINE_ID(+)
AND GSP.PARENT_SPINE_ID = PSP.PARENT_SPINE_ID(+)
AND SPS.SPINAL_POINT_ID = SPT.SPINAL_POINT_ID(+)
AND GSP.GRADE_ID = GRT.GRADE_ID(+)
AND GRT.LANGUAGE = USERENV('LANG')