APPS.PER_IE_TERMINATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 28: -- Gets assignment_id from per_all_assignments_f for above generated person_id

24: select ppos.person_id
25: from per_periods_of_service ppos
26: where period_of_service_id = c_period_of_service_id;
27:
28: -- Gets assignment_id from per_all_assignments_f for above generated person_id
29: CURSOR c_get_asg_id (c_person_id per_periods_of_service.person_id%type,
30: c_effective_date DATE ) is
31: select paaf.assignment_id
32: from per_all_assignments_f paaf

Line 32: from per_all_assignments_f paaf

28: -- Gets assignment_id from per_all_assignments_f for above generated person_id
29: CURSOR c_get_asg_id (c_person_id per_periods_of_service.person_id%type,
30: c_effective_date DATE ) is
31: select paaf.assignment_id
32: from per_all_assignments_f paaf
33: where paaf.person_id = c_person_id and
34: c_effective_date between effective_start_date
35: and effective_end_date;
36:

Line 73: p_assignment_id per_all_assignments_f.assignment_id%TYPE)

69: */
70: -- Get paye_details_id,effective_start_date and effective_end_date for above assignment_id
71:
72: CURSOR c_get_paye_details(
73: p_assignment_id per_all_assignments_f.assignment_id%TYPE)
74: IS
75: SELECT paye_details_id,
76: effective_start_date,
77: effective_end_date

Line 86: p_assignment_id per_all_assignments_f.assignment_id%TYPE)

82: ORDER BY effective_start_date;
83:
84: -- Get prsi_details_id,effective_start_date and effective_end_date for above assignment_id
85: CURSOR c_get_prsi_details(
86: p_assignment_id per_all_assignments_f.assignment_id%TYPE)
87: IS
88: SELECT prsi_details_id, effective_start_date, effective_end_date
89: FROM pay_ie_prsi_details_f
90: WHERE assignment_id = p_assignment_id AND

Line 96: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;

92: AND effective_end_date
93: ORDER BY effective_start_date;
94: --Local vriables-----
95: l_person_id per_periods_of_service.person_id%TYPE;
96: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
97: l_paye_detail_id pay_ie_paye_details_f.paye_details_id%TYPE;
98: l_paye_start_date pay_ie_paye_details_f.effective_start_date%TYPE;
99: l_paye_end_date pay_ie_paye_details_f.effective_end_date%TYPE;
100: l_prsi_detail_id pay_ie_prsi_details_f.prsi_details_id%TYPE;

Line 180: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;

176: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
177: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
178: IS
179: l_person_id per_periods_of_service.person_id%TYPE;
180: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
181: l_final_process_date DATE;
182:
183: CURSOR csr_final_process_date(p_assignment_id Number)
184: IS