APPS.PA_PURGE_PUB dependencies on PER_ALL_PEOPLE_F

Line 1341: l_person_id per_all_people_f.person_id%TYPE;

1337: x_msg_data OUT NOCOPY VARCHAR2
1338: )
1339: IS
1340:
1341: l_person_id per_all_people_f.person_id%TYPE;
1342: l_orginzation_id NUMBER;
1343: l_menu_name fnd_menus.menu_name%TYPE;
1344: l_debug_level3 NUMBER := 3;
1345: i NUMBER;

Line 1357: per_all_people_f per,

1353: fm.menu_name
1354: FROM fnd_grants fg,
1355: fnd_objects fo,
1356: fnd_menus fm,
1357: per_all_people_f per,
1358: wf_roles wfr
1359: WHERE per.person_id IN ( SELECT person_id
1360: FROM per_periods_of_service ppos
1361: WHERE ppos.person_id = per.person_id