APPS.HXT_TIME_PAY dependencies on HXT_PREM_INTERACT_RULES

Line 974: -- Factor to exist in hxt_prem_interact_rules. Match them up against premium

970: -- Step through the premium detail records of type factor that were
971: -- already inserted into the hours worked table. All are lower processing
972: -- order than the current premium with the possible exception of an overtime
973: -- base-hour which also has a processing order. Premium must be of type
974: -- Factor to exist in hxt_prem_interact_rules. Match them up against premium
975: -- interaction rules to calculate premium. Will need to get factor if not
976: -- overridden.
977: -- SIR189 - To assure that a rate or multiple gets applied to the correct
978: -- row of the the detail table, we must make sure that the hrw.seqno is

Line 996: hxt_prem_interact_rules pir,

992: eltv.hxt_premium_type
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: pay_element_types_f_tl eltt,
996: hxt_prem_interact_rules pir,
997: hxt_det_hours_worked hrw -- C421
998: WHERE hrw.tim_id = g_TIM_ID
999: AND hrw.date_worked = g_DATE_WORKED
1000: AND hrw.parent_id = g_ID -- same parent as base record

Line 1060: hxt_prem_interact_rules pir,

1056: eltv.hxt_premium_type
1057: FROM hxt_pay_element_types_f_ddf_v eltv,
1058: pay_element_types_f elt,
1059: pay_element_types_f_tl eltt,
1060: hxt_prem_interact_rules pir,
1061: hxt_det_hours_worked_f hrw -- C421
1062: WHERE hrw.tim_id = g_TIM_ID
1063: AND hrw.date_worked = g_DATE_WORKED
1064: AND hrw.parent_id = g_ID -- same parent as base record