DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on PER_TIME_PERIODS

Line 995: INDEX(ptp PER_TIME_PERIODS_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) */
997: asm.assignment_number, elt.element_name, --FORMS60
998: eltv.hxt_premium_type, --SIR65
999: eltv.hxt_premium_amount, --SIR65

Line 1088: per_time_periods ptp,

1084: hsw.attribute13,
1085: hsw.attribute14,
1086: hsw.attribute15
1087: FROM hxt_timecards_x tim,
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,

Line 1220: per_time_periods ptp,

1216: hrw.county_name,
1217: hrw.city_name,
1218: hrw.zip_code
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,

Line 1312: per_time_periods ptp,

1308: p_attribute_list VARCHAR2 )
1309: IS
1310: SELECT hrw.hours hours_worked, hrw.ROWID hrw_rowid -- OHM199
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

Line 1454: per_time_periods ptp,

1450:
1451: IS
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

Line 2650: per_time_periods ptp,

2646: hrw.city_name,
2647: hrw.zip_code,
2648: hrw.parent_id
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,

Line 3149: per_time_periods ptp,

3145: hrw.city_name,
3146: hrw.zip_code
3147: /* BSE107 */
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,