APPS.PER_RO_AEI_INFO dependencies on PER_CONTRACTS_F

Line 13: select min(effective_start_date) from per_contracts_f pcf where contract_id=P_CONTRACT_ID;

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;
14:
15:
16: --------------- procedure to validate the date of signing the contract-------------------
17: procedure check_contract_signed_date(P_ASSIGNMENT_ID in NUMBER ,

Line 30: l_contract_id per_contracts_f.contract_id%type;

26: l_assignment_start_date date;
27: l_assignment_end_date date;
28: l_contract_start_date date;
29: l_contract_end_date date;
30: l_contract_id per_contracts_f.contract_id%type;
31: l_proc VARCHAR2(50);
32: begin
33: l_proc:=g_package||'check_contract_signed_date';
34: