APPS.HXT_TIME_COLLECTION dependencies on HXT_EARNING_POLICIES

Line 40: FROM hxt_earning_policies egp,

36: CURSOR g_employee_cur (c_person_id NUMBER, c_date_worked DATE)
37: IS
38: SELECT asm.payroll_id, asm.assignment_id, asm.effective_start_date,
39: asm.effective_end_date, asmv.hxt_rotation_plan, egp.hcl_id
40: FROM hxt_earning_policies egp,
41: hxt_per_aei_ddf_v asmv,
42: per_assignment_status_types ast,
43: per_all_assignments_f asm
44: WHERE c_person_id = asm.person_id

Line 94: FROM hxt_earning_policies

90:
91: CURSOR g_earn_pol_details_cur (c_earn_pol_id NUMBER, c_date_worked DATE)
92: IS
93: SELECT fcl_earn_type, egt_id, pep_id, pip_id, hcl_id
94: FROM hxt_earning_policies
95: WHERE id = c_earn_pol_id
96: AND c_date_worked BETWEEN effective_start_date
97: AND effective_end_date;
98:

Line 171: earn_pol_id hxt_earning_policies.id%TYPE;

167: /*------------------------------
168: || Base Anchored Declarations
169: ------------------------------*/
170: project_id hxt_projects_v.project_id%TYPE;
171: earn_pol_id hxt_earning_policies.id%TYPE;
172:
173:
174: /*------------------------------------
175: || Public Module Declarations