DBA Data[Home] [Help]

APPS.HXT_TIME_PAY dependencies on PAY_ELEMENT_TYPES_F_TL

Line 813: pay_element_types_f_tl eltt,

809: eltv.hxt_processing_order
810: FROM pay_element_links_f ell,
811: hxt_pay_element_types_f_ddf_v eltv,
812: pay_element_types_f elt,
813: pay_element_types_f_tl eltt,
814: hxt_prem_eligblty_rules per,
815: per_all_assignments_f asm
816: WHERE asm.assignment_id = g_ASSIGNMENT_ID
817: AND g_DATE_WORKED between asm.effective_start_date

Line 884: ,pay_element_types_f_tl eltt

880: ,eltv.hxt_premium_amount
881: ,eltv.hxt_processing_order
882: FROM hxt_pay_element_types_f_ddf_v eltv
883: ,pay_element_types_f elt
884: ,pay_element_types_f_tl eltt
885: WHERE elt.element_type_id = p_element_type_id
886: AND g_DATE_WORKED between elt.effective_start_date
887: and elt.effective_end_date
888: AND eltt.element_type_id = elt.element_type_id

Line 948: pay_element_types_f_tl eltt,

944: eltv.hxt_earning_category,
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