DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on PAY_ELEMENT_TYPES_F

Line 238: FROM --pay_element_types_f PET

234: cp_effective_date DATE
235: )
236: IS
237: SELECT DISTINCT piv.NAME -- PIV.display_sequence
238: FROM --pay_element_types_f PET
239: pay_input_values_f piv,
240: pay_accrual_plans pap,
241: pay_net_calculation_rules pncr
242: WHERE --PET.element_type_id = cp_element_type_id

Line 848: pay_element_types_f elt,

844: per_time_periods ptp,
845: hxt_det_hours_worked_x hrw,
846: hr_lookups hcl, --GLOBAL
847: per_assignments_f asm,
848: pay_element_types_f elt,
849: hxt_pay_element_types_f_ddf_v eltv, --SIR65
850: pay_cost_allocation_keyflex pcak,
851: hr_locations_all_tl loct, --FORMS60
852: hr_locations_no_join loc, --FORMS60

Line 849: hxt_pay_element_types_f_ddf_v eltv, --SIR65

845: hxt_det_hours_worked_x hrw,
846: hr_lookups hcl, --GLOBAL
847: per_assignments_f asm,
848: pay_element_types_f elt,
849: hxt_pay_element_types_f_ddf_v eltv, --SIR65
850: pay_cost_allocation_keyflex pcak,
851: hr_locations_all_tl loct, --FORMS60
852: hr_locations_no_join loc, --FORMS60
853: fnd_flex_values ffvr

Line 980: pay_element_types_f elt,

976: per_time_periods ptp,
977: hxt_det_hours_worked_x hrw,
978: hr_lookups hcl, --GLOBAL
979: per_assignments_f asm,
980: pay_element_types_f elt,
981: pay_cost_allocation_keyflex pcak,
982:
983:
984: hr_locations_all_tl loct, --FORMS60

Line 1057: pay_element_types_f elt

1053: FROM hxt_timecards_x tim,
1054: per_time_periods ptp,
1055: hxt_det_hours_worked_f hrw,
1056: per_assignments_f asm,
1057: pay_element_types_f elt
1058: WHERE hrw.assignment_id = p_assignment_id
1059: AND asm.assignment_id = hrw.assignment_id
1060: AND asm.effective_end_date = p_asm_effective_end_date
1061: AND NVL (hrw.ffv_cost_center_id, 999999999999999) =

Line 1177: pay_element_types_f elt

1173: FROM hxt_timecards_x tim,
1174: per_time_periods ptp,
1175: hxt_det_hours_worked_f hrw,
1176: per_assignments_f asm,
1177: pay_element_types_f elt
1178: WHERE hrw.assignment_id = p_assignment_id
1179: AND asm.assignment_id = hrw.assignment_id
1180: AND asm.effective_end_date = p_asm_effective_end_date
1181: AND NVL (hrw.ffv_cost_center_id, 999999999999999) =

Line 2276: pay_element_types_f elt,

2272: per_time_periods ptp,
2273: hxt_det_hours_worked_f hrw,
2274: hr_lookups hcl, --GLOBAL
2275: per_assignments_f asm,
2276: pay_element_types_f elt,
2277: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2278: pay_cost_allocation_keyflex pcak,
2279:
2280: /*TA36fnd_flex_values ffvl, */

Line 2277: hxt_pay_element_types_f_ddf_v eltv, --SIR65

2273: hxt_det_hours_worked_f hrw,
2274: hr_lookups hcl, --GLOBAL
2275: per_assignments_f asm,
2276: pay_element_types_f elt,
2277: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2278: pay_cost_allocation_keyflex pcak,
2279:
2280: /*TA36fnd_flex_values ffvl, */
2281: hr_locations_all_tl loct, --FORMS60

Line 2757: pay_element_types_f elt,

2753: per_time_periods ptp,
2754: hxt_det_hours_worked_f hrw,
2755: hr_lookups hcl, --GLOBAL
2756: per_assignments_f asm,
2757: pay_element_types_f elt,
2758: pay_cost_allocation_keyflex pcak,
2759:
2760: /*TA36fnd_flex_values ffvl, */
2761: hr_locations_all_tl loct, --FORMS60