APPS.HXT_TIME_PAY dependencies on PAY_ELEMENT_LINKS_F

Line 396: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;

392: -- not just overtime. Was ignoring earn types of OTH etc.
393: -- 1/22/98 SIR092 Hours are not written to premium types of FIXED.
394: --
395: v_amount hxt_det_hours_worked.amount%type := null; --SIR029
396: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
397: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
398:
399: CURSOR next_id_cur IS
400: SELECT hxt_seqno.nextval next_id

Line 828: l_costable_type pay_element_links_f.costable_type%TYPE;

824:
825: l_min_detail_seqno NUMBER;
826: l_max_detail_seqno NUMBER;
827:
828: l_costable_type pay_element_links_f.costable_type%TYPE;
829: l_ffv_cost_center_id hxt_det_hours_worked_f.ffv_cost_center_id%TYPE;
830:
831: l_rowid ROWID;
832: l_object_version_number NUMBER DEFAULT NULL;

Line 852: FROM pay_element_links_f ell,

848: SELECT /* +INDEX (ell pay_pk) +INDEX(per per_pk) */
849: per.elt_premium_id, eltt.element_name, eltv.hxt_earning_category,
850: eltv.hxt_premium_type, eltv.hxt_premium_amount,
851: eltv.hxt_processing_order
852: FROM pay_element_links_f ell,
853: hxt_pay_element_types_f_ddf_v eltv,
854: pay_element_types_f elt,
855: pay_element_types_f_tl eltt,
856: hxt_prem_eligblty_rules per,