DBA Data[Home] [Help]

APPS.HXT_TIME_CLOCK dependencies on HXT_EARNING_POLICIES

Line 92: FROM hxt_earning_policies egp,

88: asm.effective_start_date,
89: asm.effective_end_date,
90: aeiv.hxt_rotation_plan, --SIR344
91: egp.hcl_id
92: FROM hxt_earning_policies egp,
93: --ORACLE per_assignments_f_dfv asmv,
94: hxt_per_aei_ddf_v aeiv,--ORACLE
95: per_assignment_status_types ast,
96: per_assignments_f asm

Line 1031: -- FROM hxt_earning_policies egp,

1027: -- egp.pep_id,
1028: -- egp.pip_id,
1029: -- wsh.off_shift_prem_id,
1030: -- wsh.shift_diff_ovrrd_id
1031: -- FROM hxt_earning_policies egp,
1032: ----ORACLE per_assignments_f_dfv asmv,
1033: -- hxt_per_aei_ddf_v aeiv, --ORACLE
1034: -- per_assignment_status_types ast,
1035: -- per_assignments_f asm,

Line 1070: FROM hxt_earning_policies egp,

1066: egp.fcl_earn_type,
1067: egp.egt_id,
1068: egp.pep_id,
1069: egp.pip_id
1070: FROM hxt_earning_policies egp,
1071: hxt_per_aei_ddf_v aeiv,
1072: per_assignment_status_types past,
1073: per_assignments_f paf
1074: WHERE c_assignment_id = paf.assignment_id