APPS.PER_CHECKLIST_EVENTS dependencies on PER_PEOPLE_F

Line 1391: l_person_id per_people_f.person_id%type;

1387: --
1388: -- ER 8861932 starts
1389: FUNCTION get_person_id (p_transaction_id IN VARCHAR2) RETURN NUMBER
1390: IS
1391: l_person_id per_people_f.person_id%type;
1392: BEGIN
1393: select substr(p_transaction_id,instr(p_transaction_id,'-')+1,length(p_transaction_id))
1394: INTO l_person_id FROM dual;
1395:

Line 1401: l_person_id per_people_f.person_id%type;

1397: END get_person_id ;
1398: --
1399: FUNCTION get_supervisor_id (p_transaction_id IN VARCHAR2) RETURN NUMBER
1400: IS
1401: l_person_id per_people_f.person_id%type;
1402: l_supervisor_id per_assignments_f.supervisor_id%type;
1403: l_effective_date per_ben_identified_events.effective_date%type;
1404: BEGIN
1405: select substr(p_transaction_id,instr(p_transaction_id,'-')+1,length(p_transaction_id))