DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on PER_TIME_PERIODS

Line 844: per_time_periods ptp,

840: hrw.county_name,
841: hrw.city_name,
842: hrw.zip_code
843: FROM hxt_timecards_x tim,
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,

Line 976: per_time_periods ptp,

972: hrw.county_name,
973: hrw.city_name,
974: hrw.zip_code
975: FROM hxt_timecards_x tim,
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,

Line 1054: per_time_periods ptp,

1050: p_ZIP_CODE VARCHAR2 )
1051: IS
1052: SELECT hrw.hours hours_worked, hrw.ROWID hrw_rowid -- OHM199
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

Line 1174: per_time_periods ptp,

1170:
1171: IS
1172: SELECT hrw.amount amount, hrw.ROWID hrw_rowid -- OHM199
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

Line 2272: per_time_periods ptp,

2268: hrw.county_name,
2269: hrw.city_name,
2270: hrw.zip_code
2271: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
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,

Line 2753: per_time_periods ptp,

2749: hrw.city_name,
2750: hrw.zip_code
2751: /* BSE107 */
2752: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
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,