VIEW: APPS.HRIFV_GRADE_RATES_BG

Source

View Text - Preformatted

SELECT grd.name grade_name , grd.date_from grade_date_from , grd.date_to grade_date_to , grl.effective_start_date grade_rule_start_date , grl.effective_end_date grade_rule_end_date , rat.name grade_rate_name , hr_general.decode_lookup('UNITS',rat.rate_uom) unit_of_measure , grl.maximum grade_maximum , grl.mid_value grade_mid_value , grl.minimum grade_minimum , grl.value grade_rate_value , ppb.grade_annualization_factor grade_annualization_factor , ppb.name pay_basis_name ,'_DF:PAY:PAY_RATES:rat' , grl.grade_rule_id grade_rule_id , grd.grade_id grade_id , grd.grade_definition_id grade_definition_id , grd.business_group_id grade_business_group_id , rat.rate_id grade_rate_id , grl.grade_or_spinal_point_id grade_or_spinal_point_id , ppb.pay_basis_id pay_basis_id from pay_grade_rules_f grl , per_grades grd , pay_rates rat , per_pay_bases ppb WHERE grd.grade_id = grl.grade_or_spinal_point_id (+) and NVL(grl.rate_type,'G') = 'G' and grl.rate_id = rat.rate_id (+) and NVL(ppb.rate_id, -5) = nvl(rat.rate_id, NVL(ppb.rate_id, -5)) and grd.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, grd.business_group_id ) WITH READ ONLY

View Text - HTML Formatted

SELECT GRD.NAME GRADE_NAME
, GRD.DATE_FROM GRADE_DATE_FROM
, GRD.DATE_TO GRADE_DATE_TO
, GRL.EFFECTIVE_START_DATE GRADE_RULE_START_DATE
, GRL.EFFECTIVE_END_DATE GRADE_RULE_END_DATE
, RAT.NAME GRADE_RATE_NAME
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, RAT.RATE_UOM) UNIT_OF_MEASURE
, GRL.MAXIMUM GRADE_MAXIMUM
, GRL.MID_VALUE GRADE_MID_VALUE
, GRL.MINIMUM GRADE_MINIMUM
, GRL.VALUE GRADE_RATE_VALUE
, PPB.GRADE_ANNUALIZATION_FACTOR GRADE_ANNUALIZATION_FACTOR
, PPB.NAME PAY_BASIS_NAME
, '_DF:PAY:PAY_RATES:RAT'
, GRL.GRADE_RULE_ID GRADE_RULE_ID
, GRD.GRADE_ID GRADE_ID
, GRD.GRADE_DEFINITION_ID GRADE_DEFINITION_ID
, GRD.BUSINESS_GROUP_ID GRADE_BUSINESS_GROUP_ID
, RAT.RATE_ID GRADE_RATE_ID
, GRL.GRADE_OR_SPINAL_POINT_ID GRADE_OR_SPINAL_POINT_ID
, PPB.PAY_BASIS_ID PAY_BASIS_ID
FROM PAY_GRADE_RULES_F GRL
, PER_GRADES GRD
, PAY_RATES RAT
, PER_PAY_BASES PPB
WHERE GRD.GRADE_ID = GRL.GRADE_OR_SPINAL_POINT_ID (+)
AND NVL(GRL.RATE_TYPE
, 'G') = 'G'
AND GRL.RATE_ID = RAT.RATE_ID (+)
AND NVL(PPB.RATE_ID
, -5) = NVL(RAT.RATE_ID
, NVL(PPB.RATE_ID
, -5))
AND GRD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, GRD.BUSINESS_GROUP_ID ) WITH READ ONLY