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
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
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