APPS.IRC_APPROVALS dependencies on PER_PEOPLE_F

Line 1274: cursor csr_app(c_person_id per_people_f.person_id%TYPE) is

1270: p_creator_person_id per_all_people_f.person_id%type default null;
1271: c_approver_id per_all_people_f.person_id%type default null;
1272: c_top_approver_id per_all_people_f.person_id%type default null;
1273:
1274: cursor csr_app(c_person_id per_people_f.person_id%TYPE) is
1275: select supervisor_id
1276: from per_all_assignments_f
1277: where person_id = c_person_id
1278: and primary_flag = 'Y'