DBA Data[Home] [Help]

APPS.AR_CMGT_UTIL dependencies on PER_PEOPLE_F

Line 768: l_person_id per_people_f.person_id%type;

764: END check_delete_permissions;
765:
766: FUNCTION get_person_based_on_resource ( l_resource_id IN NUMBER)
767: return NUMBER IS
768: l_person_id per_people_f.person_id%type;
769: CURSOR c_person_id IS
770: SELECT c.source_id
771: FROM jtf_rs_resource_extns c
772: WHERE c.category = 'EMPLOYEE'

Line 795: l_person_id per_people_f.person_id%type;

791:
792: FUNCTION get_person_based_on_cf ( l_case_folder_id IN NUMBER)
793: return NUMBER IS
794: l_resource_id ar_cmgt_case_folders.credit_analyst_id%type;
795: l_person_id per_people_f.person_id%type;
796: CURSOR c_res_id IS
797: SELECT credit_analyst_id
798: FROM ar_cmgt_case_folders
799: WHERE case_folder_id = l_case_folder_id;