APPS.HXT_TIME_PAY dependencies on PAY_ELEMENT_LINKS_F

Line 354: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;

350: -- not just overtime. Was ignoring earn types of OTH etc.
351: -- 1/22/98 SIR092 Hours are not written to premium types of FIXED.
352: --
353: v_amount hxt_det_hours_worked.amount%type := null; --SIR029
354: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
355: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
356:
357: CURSOR next_id_cur IS
358: SELECT hxt_seqno.nextval next_id

Line 786: l_costable_type pay_element_links_f.costable_type%TYPE;

782:
783: l_min_detail_seqno NUMBER;
784: l_max_detail_seqno NUMBER;
785:
786: l_costable_type pay_element_links_f.costable_type%TYPE;
787: l_ffv_cost_center_id hxt_det_hours_worked_f.ffv_cost_center_id%TYPE;
788:
789: l_rowid ROWID;
790: l_object_version_number NUMBER DEFAULT NULL;

Line 810: FROM pay_element_links_f ell,

806: SELECT /* +INDEX (ell pay_pk) +INDEX(per per_pk) */
807: per.elt_premium_id, eltt.element_name, eltv.hxt_earning_category,
808: eltv.hxt_premium_type, eltv.hxt_premium_amount,
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,