1: PACKAGE BODY PER_PL_AEI_INFO AS
2: /* $Header: peplaeip.pkb 120.3 2006/09/13 10:19:05 mseshadr noship $ */
3:
4:
5: g_package varchar2(16):='PER_PL_AEI_INFO.';
1: PACKAGE BODY PER_PL_AEI_INFO AS
2: /* $Header: peplaeip.pkb 120.3 2006/09/13 10:19:05 mseshadr noship $ */
3:
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:
474: hr_utility.raise_error;
475:
476: END UPDATE_PL_ASSGT_EXTRA_INFO; --end procedure update
477:
478: END PER_PL_AEI_INFO ; --end package