eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.HRI_MB_GRADE_RATE_V

Source

View Text - Preformatted


SELECT ppb.grade_annualization_factor * to_number(grl.maximum) annualized_grade_max , ppb.grade_annualization_factor * to_number(grl.mid_value) annualized_grade_mid , ppb.grade_annualization_factor * to_number(grl.minimum) annualized_grade_min , grl.maximum grade_max , grl.mid_value grade_mid , grl.minimum grade_min , grl.value grade_rate_value , ppb.grade_annualization_factor grade_annualization_factor , ppb.pay_annualization_factor salary_annualization_factor , GREATEST(asg.effective_start_date ,grl.effective_start_date) effective_start_date , LEAST(asg.effective_end_date ,grl.effective_end_date) effective_end_date , asg.assignment_id assignment_id , asg.person_id person_id , asg.business_group_id business_group_id , asg.organization_id organization_id , asg.location_id location_id , asg.job_id job_id , asg.grade_id grade_id , asg.position_id position_id , asg.supervisor_id supervisor_person_id , asg.assignment_status_type_id assignment_status_type_id , asg.pay_basis_id salary_basis_id , NVL(asg.set_of_books_id, -1) set_of_books_id , asg.period_of_service_id period_of_service_id , asg.employment_category employment_category_code , asg.primary_flag primary_flag_code , grl.grade_rule_id grade_rule_id , grl.rate_id rate_id , ppb.pay_basis_id pay_basis_id , NVL(pet.input_currency_code, 'NA_EDW') currency_code , NVL(pet.output_currency_code, 'NA_EDW') output_currency_code , NVL(grl.currency_code,'NA_EDW') grade_rule_currency_code , GREATEST(asg.last_update_date ,grl.last_update_date ) last_change_date , asg.last_update_date asg_last_update_date , grl.last_update_date grl_last_update_date FROM per_all_assignments_f asg , per_periods_of_service pps , pay_grade_rules_f grl , pay_rates rat , per_pay_bases ppb , pay_input_values_f piv , pay_element_types_f pet WHERE grl.rate_type = 'G' AND asg.assignment_type = 'E' AND asg.period_of_service_id = pps.period_of_service_id AND asg.pay_basis_id = ppb.pay_basis_id AND asg.grade_id = grl.grade_or_spinal_point_id AND grl.rate_id = rat.rate_id AND grl.rate_id = ppb.rate_id AND ppb.input_value_id = piv.input_value_id AND piv.element_type_id = pet.element_type_id AND (pps.actual_termination_date IS NULL OR pps.actual_termination_date >= GREATEST(grl.effective_start_date ,asg.effective_start_date) ) AND grl.effective_start_date BETWEEN piv.effective_start_date AND piv.effective_end_date AND grl.effective_start_date BETWEEN pet.effective_start_date AND pet.effective_end_date AND ( (asg.effective_start_date BETWEEN grl.effective_start_date AND grl.effective_end_date ) OR (grl.effective_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date ) ) WITH READ ONLY

View Text - HTML Formatted

SELECT PPB.GRADE_ANNUALIZATION_FACTOR * TO_NUMBER(GRL.MAXIMUM) ANNUALIZED_GRADE_MAX
, PPB.GRADE_ANNUALIZATION_FACTOR * TO_NUMBER(GRL.MID_VALUE) ANNUALIZED_GRADE_MID
, PPB.GRADE_ANNUALIZATION_FACTOR * TO_NUMBER(GRL.MINIMUM) ANNUALIZED_GRADE_MIN
, GRL.MAXIMUM GRADE_MAX
, GRL.MID_VALUE GRADE_MID
, GRL.MINIMUM GRADE_MIN
, GRL.VALUE GRADE_RATE_VALUE
, PPB.GRADE_ANNUALIZATION_FACTOR GRADE_ANNUALIZATION_FACTOR
, PPB.PAY_ANNUALIZATION_FACTOR SALARY_ANNUALIZATION_FACTOR
, GREATEST(ASG.EFFECTIVE_START_DATE
, GRL.EFFECTIVE_START_DATE) EFFECTIVE_START_DATE
, LEAST(ASG.EFFECTIVE_END_DATE
, GRL.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.PERSON_ID PERSON_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.LOCATION_ID LOCATION_ID
, ASG.JOB_ID JOB_ID
, ASG.GRADE_ID GRADE_ID
, ASG.POSITION_ID POSITION_ID
, ASG.SUPERVISOR_ID SUPERVISOR_PERSON_ID
, ASG.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, ASG.PAY_BASIS_ID SALARY_BASIS_ID
, NVL(ASG.SET_OF_BOOKS_ID
, -1) SET_OF_BOOKS_ID
, ASG.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, ASG.EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY_CODE
, ASG.PRIMARY_FLAG PRIMARY_FLAG_CODE
, GRL.GRADE_RULE_ID GRADE_RULE_ID
, GRL.RATE_ID RATE_ID
, PPB.PAY_BASIS_ID PAY_BASIS_ID
, NVL(PET.INPUT_CURRENCY_CODE
, 'NA_EDW') CURRENCY_CODE
, NVL(PET.OUTPUT_CURRENCY_CODE
, 'NA_EDW') OUTPUT_CURRENCY_CODE
, NVL(GRL.CURRENCY_CODE
, 'NA_EDW') GRADE_RULE_CURRENCY_CODE
, GREATEST(ASG.LAST_UPDATE_DATE
, GRL.LAST_UPDATE_DATE ) LAST_CHANGE_DATE
, ASG.LAST_UPDATE_DATE ASG_LAST_UPDATE_DATE
, GRL.LAST_UPDATE_DATE GRL_LAST_UPDATE_DATE
FROM PER_ALL_ASSIGNMENTS_F ASG
, PER_PERIODS_OF_SERVICE PPS
, PAY_GRADE_RULES_F GRL
, PAY_RATES RAT
, PER_PAY_BASES PPB
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F PET
WHERE GRL.RATE_TYPE = 'G'
AND ASG.ASSIGNMENT_TYPE = 'E'
AND ASG.PERIOD_OF_SERVICE_ID = PPS.PERIOD_OF_SERVICE_ID
AND ASG.PAY_BASIS_ID = PPB.PAY_BASIS_ID
AND ASG.GRADE_ID = GRL.GRADE_OR_SPINAL_POINT_ID
AND GRL.RATE_ID = RAT.RATE_ID
AND GRL.RATE_ID = PPB.RATE_ID
AND PPB.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND (PPS.ACTUAL_TERMINATION_DATE IS NULL OR PPS.ACTUAL_TERMINATION_DATE >= GREATEST(GRL.EFFECTIVE_START_DATE
, ASG.EFFECTIVE_START_DATE) )
AND GRL.EFFECTIVE_START_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND GRL.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND ( (ASG.EFFECTIVE_START_DATE BETWEEN GRL.EFFECTIVE_START_DATE
AND GRL.EFFECTIVE_END_DATE ) OR (GRL.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE ) ) WITH READ ONLY