DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on PER_ASSIGNMENTS_F

Line 847: per_assignments_f asm,

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,
849: hxt_pay_element_types_f_ddf_v eltv, --SIR65
850: pay_cost_allocation_keyflex pcak,
851: hr_locations_all_tl loct, --FORMS60

Line 979: per_assignments_f asm,

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,
981: pay_cost_allocation_keyflex pcak,
982:
983:

Line 1056: per_assignments_f asm,

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
1059: AND asm.assignment_id = hrw.assignment_id
1060: AND asm.effective_end_date = p_asm_effective_end_date

Line 1176: per_assignments_f asm,

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
1179: AND asm.assignment_id = hrw.assignment_id
1180: AND asm.effective_end_date = p_asm_effective_end_date

Line 2275: per_assignments_f asm,

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,
2277: hxt_pay_element_types_f_ddf_v eltv, --SIR65
2278: pay_cost_allocation_keyflex pcak,
2279:

Line 2756: per_assignments_f asm,

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,
2758: pay_cost_allocation_keyflex pcak,
2759:
2760: /*TA36fnd_flex_values ffvl, */