APPS.HXT_RETRO_MIX dependencies on PAY_ELEMENT_TYPES_F

Line 273: FROM --pay_element_types_f PET

269: cp_effective_date DATE
270: )
271: IS
272: SELECT DISTINCT piv.NAME -- PIV.display_sequence
273: FROM --pay_element_types_f PET
274: pay_input_values_f piv,
275: pay_accrual_plans pap,
276: pay_net_calculation_rules pncr
277: WHERE --PET.element_type_id = cp_element_type_id

Line 992: INDEX(elt PAY_ELEMENT_TYPES_F_PK)

988: INDEX(hrw.HXT_DET_HOURS_WORKED_F HXT_DET_HOURS_WORKED_F_TIM_FK)
989: INDEX(ffvr FND_FLEX_VALUES_U1)
990: INDEX(loct HR_LOCATIONS_ALL_TL_PK)
991: INDEX(loc.HR_LOCATIONS_ALL HR_LOCATIONS_PK)
992: INDEX(elt PAY_ELEMENT_TYPES_F_PK)
993: INDEX(eltv.HXT_ADD_ELEM_INFO_F HXT_ADD_ELEM_INFO_ON1)
994: INDEX(pcak PAY_COST_ALLOCATION_KEYFLE_PK)
995: INDEX(ptp PER_TIME_PERIODS_PK)
996: INDEX(asm.PAA PER_ASSIGNMENTS_F_PK) */

Line 1093: pay_element_types_f elt,

1089: hxt_det_hours_worked_x hrw,
1090: hxt_sum_hours_worked_x hsw,
1091: hr_lookups hcl, --GLOBAL
1092: per_assignments_f asm,
1093: pay_element_types_f elt,
1094: hxt_pay_element_types_f_ddf_v eltv, --SIR65
1095: pay_cost_allocation_keyflex pcak,
1096: hr_locations_all_tl loct, --FORMS60
1097: hr_locations_no_join loc, --FORMS60

Line 1094: hxt_pay_element_types_f_ddf_v eltv, --SIR65

1090: hxt_sum_hours_worked_x hsw,
1091: hr_lookups hcl, --GLOBAL
1092: per_assignments_f asm,
1093: pay_element_types_f elt,
1094: hxt_pay_element_types_f_ddf_v eltv, --SIR65
1095: pay_cost_allocation_keyflex pcak,
1096: hr_locations_all_tl loct, --FORMS60
1097: hr_locations_no_join loc, --FORMS60
1098: fnd_flex_values ffvr

Line 1224: pay_element_types_f elt,

1220: per_time_periods ptp,
1221: hxt_det_hours_worked_x hrw,
1222: hr_lookups hcl, --GLOBAL
1223: per_assignments_f asm,
1224: pay_element_types_f elt,
1225: pay_cost_allocation_keyflex pcak,
1226:
1227:
1228: hr_locations_all_tl loct, --FORMS60

Line 1316: pay_element_types_f elt

1312: per_time_periods ptp,
1313: hxt_det_hours_worked_f hrw,
1314: hxt_sum_hours_worked_f hsw,
1315: per_assignments_f asm,
1316: pay_element_types_f elt
1317: WHERE hrw.assignment_id = p_assignment_id
1318: AND asm.assignment_id = hrw.assignment_id
1319: AND hrw.parent_id = hsw.id
1320: -- Bug 12655429

Line 1457: pay_element_types_f elt

1453: FROM hxt_timecards_x tim,
1454: per_time_periods ptp,
1455: hxt_det_hours_worked_f hrw,
1456: per_assignments_f asm,
1457: pay_element_types_f elt
1458: WHERE hrw.assignment_id = p_assignment_id
1459: AND asm.assignment_id = hrw.assignment_id
1460: AND asm.effective_end_date = p_asm_effective_end_date
1461: AND NVL (hrw.ffv_cost_center_id, 999999999999999) =

Line 2654: pay_element_types_f elt,

2650: per_time_periods ptp,
2651: hxt_det_hours_worked_f hrw,
2652: hr_lookups hcl, --GLOBAL
2653: per_assignments_f asm,
2654: pay_element_types_f elt,
2655: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2656: pay_cost_allocation_keyflex pcak,
2657:
2658: /*TA36fnd_flex_values ffvl, */

Line 2655: hxt_pay_element_types_f_ddf_v eltv, --SIR65

2651: hxt_det_hours_worked_f hrw,
2652: hr_lookups hcl, --GLOBAL
2653: per_assignments_f asm,
2654: pay_element_types_f elt,
2655: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2656: pay_cost_allocation_keyflex pcak,
2657:
2658: /*TA36fnd_flex_values ffvl, */
2659: hr_locations_all_tl loct, --FORMS60

Line 3153: pay_element_types_f elt,

3149: per_time_periods ptp,
3150: hxt_det_hours_worked_f hrw,
3151: hr_lookups hcl, --GLOBAL
3152: per_assignments_f asm,
3153: pay_element_types_f elt,
3154: pay_cost_allocation_keyflex pcak,
3155:
3156: /*TA36fnd_flex_values ffvl, */
3157: hr_locations_all_tl loct, --FORMS60