APPS.HXT_RETRO_MIX dependencies on PER_ASSIGNMENTS_F

Line 996: INDEX(asm.PAA PER_ASSIGNMENTS_F_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) */
997: asm.assignment_number, elt.element_name, --FORMS60
998: eltv.hxt_premium_type, --SIR65
999: eltv.hxt_premium_amount, --SIR65
1000: eltv.hxt_earning_category, --SIR65

Line 1092: per_assignments_f asm,

1088: per_time_periods ptp,
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

Line 1223: per_assignments_f asm,

1219: FROM hxt_timecards_x tim,
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:

Line 1315: per_assignments_f asm,

1311: FROM hxt_timecards_x tim,
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

Line 1456: per_assignments_f asm,

1452: SELECT hrw.amount amount, hrw.ROWID hrw_rowid -- OHM199
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

Line 2653: per_assignments_f asm,

2649: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
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:

Line 3152: per_assignments_f asm,

3148: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
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, */