APPS.PER_RO_AEI_INFO dependencies on PER_ALL_ASSIGNMENTS_F

Line 9: select min(effective_start_date),max(effective_end_date) from per_all_assignments_f where ASSIGNMENT_ID=P_ASSIGNMENT_ID;

5: g_package varchar2(16):='PER_RO_AEI_INFO.';
6:
7: --cursor to get the assignment start date and end date
8: cursor csr_assgt_start_date( P_ASSIGNMENT_ID in number)is
9: select min(effective_start_date),max(effective_end_date) from per_all_assignments_f where ASSIGNMENT_ID=P_ASSIGNMENT_ID;
10:
11: --cursor to get the contract start date and end date
12: cursor csr_contract_start_date( P_CONTRACT_ID in number)is
13: select min(effective_start_date) from per_contracts_f pcf where contract_id=P_CONTRACT_ID;

Line 22: select contract_id from per_all_assignments_f paaf

18: P_AEI_INFORMATION1 in varchar2)
19: as
20: --CURSOR to fetch the contract id a
21: CURSOR csr_get_contract_id(l_assignment_end_date date ) IS
22: select contract_id from per_all_assignments_f paaf
23: where paaf.assignment_id=p_assignment_id
24: and paaf.effective_end_date = l_assignment_end_date;
25:
26: l_assignment_start_date date;

Line 136: l_assignment_id per_all_assignments_f.assignment_id%type;

132: cursor csr_get_assignment_id IS
133: select assignment_id from per_assignment_extra_info
134: where aei_information_category = p_aei_information_category
135: and ASSIGNMENT_EXTRA_INFO_ID = P_ASSIGNMENT_EXTRA_INFO_ID;
136: l_assignment_id per_all_assignments_f.assignment_id%type;
137: l_proc varchar2(60);
138:
139: begin
140: l_proc:= g_package||'UPDATE_RO_ASSGT_EXTRA_INFO';