758: */
759:
760: SELECT full_name
761: INTO l_disp_name
762: FROM PER_ALL_PEOPLE_F --
764: AND trunc(sysdate) BETWEEN effective_start_date
765: AND effective_end_date;
766:
1586:
1587: CURSOR c1 (p_empid NUMBER, p_business_group_id NUMBER) IS
1588: SELECT pafe.supervisor_id
1589: FROM Per_All_Assignments_f pafe, --
1590: Per_All_People_f ppfs, --
1592: Per_Person_Types ppts
1593: WHERE pafe.business_group_id = p_business_group_id
1594: AND pafe.person_id = p_empid
1617:
1618: CURSOR C2 ( p_empid NUMBER ) IS
1619: SELECT Pafe.supervisor_id
1620: FROM Per_All_Assignments_f pafe, --
1621: Per_All_People_f ppfs, --
1623: Per_Person_Types ppts
1624: WHERE pafe.person_id = p_empid
1625: AND Trunc(SYSDATE) BETWEEN pafe.Effective_Start_Date