APPS.HXT_TIME_CLOCK dependencies on PER_ASSIGNMENTS_F

Line 56: l_bus_grp_id per_assignments_f.business_group_id%TYPE DEFAULT NULL;

52: err_buf OUT NOCOPY VARCHAR2)IS
53: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;
54: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
55: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
56: l_bus_grp_id per_assignments_f.business_group_id%TYPE DEFAULT NULL;
57: l_timecard_id hxt_timecards.id%TYPE DEFAULT NULL;
58: l_date_worked DATE DEFAULT NULL;
59: l_time_period_id per_time_periods.time_period_id%TYPE DEFAULT NULL;
60: l_start_date DATE DEFAULT NULL;

Line 93: --ORACLE per_assignments_f_dfv asmv,

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
97: WHERE c_person_id = asm.person_id

Line 96: per_assignments_f asm

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
97: WHERE c_person_id = asm.person_id
98: AND ast.assignment_status_type_id = asm.assignment_status_type_id
99: AND ast.pay_system_status = 'P' -- Check payroll status
100: --ORACLE AND asmv.row_id = asm.rowid

Line 113: from per_assignments_f asm

109: -- Fassadi 25/OCT/00 Get the Bug_id for the get_person_id procedure.
110: --
111: Cursor l_bus_grp_cur ( p_asg_id NUMBER ) is
112: select business_group_id
113: from per_assignments_f asm
114: where asm.assignment_id = p_asg_id;
115:
116: --this to fix bug 756293
117: --

Line 1032: ----ORACLE per_assignments_f_dfv asmv,

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,
1036: -- hxt_shifts sht,

Line 1035: -- per_assignments_f asm,

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,
1036: -- hxt_shifts sht,
1037: -- hxt_weekly_work_schedules wws,
1038: -- hxt_work_shifts wsh,
1039: -- hxt_rotation_schedules rts

Line 1073: per_assignments_f paf

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
1075: AND c_date_worked BETWEEN paf.effective_start_date AND paf.effective_end_date
1076: AND past.assignment_status_type_id = paf.assignment_status_type_id
1077: AND past.pay_system_status = 'P' -- Check payroll status