APPS.PER_CHECKLIST_EVENTS dependencies on PER_ASSIGNMENTS_F

Line 1402: l_supervisor_id per_assignments_f.supervisor_id%type;

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))
1406: INTO l_person_id FROM dual;

Line 1416: FROM per_assignments_f

1412: AND person_id = l_person_id;
1413:
1414: -- get supervisor_id from assignment table as of the effective_date
1415: SELECT supervisor_id INTO l_supervisor_id
1416: FROM per_assignments_f
1417: WHERE person_id = l_person_id
1418: AND l_effective_date BETWEEN effective_start_date AND effective_end_date
1419: AND assignment_type = 'E'
1420: AND primary_flag = 'Y';