APPS.PA_PURGE_PUB dependencies on PER_ALL_PEOPLE_F

Line 1360: l_person_id per_all_people_f.person_id%TYPE;

1356: x_msg_data OUT NOCOPY VARCHAR2
1357: )
1358: IS
1359:
1360: l_person_id per_all_people_f.person_id%TYPE;
1361: l_orginzation_id NUMBER;
1362: l_menu_name fnd_menus.menu_name%TYPE;
1363: l_debug_level3 NUMBER := 3;
1364: i NUMBER;

Line 1376: per_all_people_f per,

1372: fm.menu_name
1373: FROM fnd_grants fg,
1374: fnd_objects fo,
1375: fnd_menus fm,
1376: per_all_people_f per,
1377: wf_roles wfr
1378: WHERE per.person_id IN ( SELECT person_id
1379: FROM per_periods_of_service ppos
1380: WHERE ppos.person_id = per.person_id