APPS.PA_PURGE_PUB dependencies on FND_MENUS

Line 1362: l_menu_name fnd_menus.menu_name%TYPE;

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;
1365: l_local_error_flag VARCHAR2(1) :='N';
1366: l_grants_deleted NUMBER := 0;

Line 1375: fnd_menus fm,

1371: (to_number(fg.instance_pk1_value)) organization_id,
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