DBA Data[Home] [Help]

APPS.HXT_TIME_PAY dependencies on HXT_PREM_INTERACT_RULES

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

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

Line 949: hxt_prem_interact_rules pir,

945: eltv.hxt_premium_type
946: FROM hxt_pay_element_types_f_ddf_v eltv,
947: pay_element_types_f elt,
948: pay_element_types_f_tl eltt,
949: hxt_prem_interact_rules pir,
950: hxt_det_hours_worked hrw -- C421
951: WHERE hrw.tim_id = g_TIM_ID
952: AND hrw.date_worked = g_DATE_WORKED
953: AND hrw.parent_id = g_ID -- same parent as base record