DBA Data[Home] [Help]

APPS.PER_PL_AEI_INFO dependencies on PER_ALL_ASSIGNMENTS_F

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

4:
5: g_package varchar2(16):='PER_PL_AEI_INFO.';
6:
7: cursor csr_assgt_start_date( R_ASSIGNMENT_ID in number)is
8: select min(effective_start_date),max(effective_end_date) from per_all_assignments_f where ASSIGNMENT_ID=R_ASSIGNMENT_ID;
9:
10:
11: -- private procedure to validate data
12: -- entered during creation of payment conditions.