DBA Data[Home] [Help]

APPS.IBU_DYN_USER_GROUPS_PKG dependencies on PER_ALL_PEOPLE_F

Line 408: FROM per_all_people_f

404:
405: -- to get the person detail of an employee
406: CURSOR c_emp_dtls(c_person_id IN NUMBER) IS
407: SELECT full_name
408: FROM per_all_people_f
409: WHERE person_id = c_person_id
410: ORDER BY effective_start_date desc;
411:
412: begin

Line 687: FROM per_all_people_f

683:
684: -- to get the person detail of an employee
685: CURSOR c_emp_dtls(c_person_id IN NUMBER) IS
686: SELECT full_name
687: FROM per_all_people_f
688: WHERE person_id = c_person_id
689: ORDER BY effective_start_date desc;
690:
691: createResGrpExp Exception;

Line 1269: FROM per_all_people_f

1265:
1266: -- to get the person detail of an employee
1267: CURSOR c_emp_dtls(c_person_id IN NUMBER) IS
1268: SELECT full_name
1269: FROM per_all_people_f
1270: WHERE person_id = c_person_id
1271: ORDER BY effective_start_date desc;
1272:
1273: