APPS.ORACLEMYPAGE dependencies on FND_RESPONSIBILITY_VL

Line 696: fnd_responsibility_vl a,

692: fsg.SECURITY_GROUP_ID,
693: fsg.security_group_key,
694: fa.application_short_name
695: from FND_SECURITY_GROUPS_VL fsg,
696: fnd_responsibility_vl a,
697: FND_USER_RESP_GROUPS b,
698: FND_APPLICATION fa
699: where b.user_id = icx_sec.g_user_id
700: and b.start_date <= sysdate

Line 725: fnd_responsibility_vl a,

721: fsg.SECURITY_GROUP_ID,
722: fsg.security_group_key,
723: fa.application_short_name
724: from FND_SECURITY_GROUPS_VL fsg,
725: fnd_responsibility_vl a,
726: FND_USER_RESP_GROUPS b,
727: FND_APPLICATION fa
728: where b.user_id = icx_sec.g_user_id
729: and b.start_date <= sysdate

Line 881: FND_RESPONSIBILITY_VL a,

877: -- how many valid resps?
878: -- 1584711 nlbarlow remove order by
879: select count(*) INTO l_resps_count
880: from FND_SECURITY_GROUPS_VL fsg,
881: FND_RESPONSIBILITY_VL a,
882: FND_USER_RESP_GROUPS b
883: where b.user_id = l_user_id
884: and b.start_date <= sysdate
885: and (b.end_date is null or b.end_date > sysdate)

Line 910: FND_RESPONSIBILITY_VL a,

906:
907: end if;
908: select a.version INTO l_resp_type
909: from FND_SECURITY_GROUPS_VL fsg,
910: FND_RESPONSIBILITY_VL a,
911: FND_USER_RESP_GROUPS b
912: where b.user_id = l_user_id
913: and b.start_date <= sysdate
914: and (b.end_date is null or b.end_date > sysdate)

Line 945: fnd_responsibility_vl a,

941: for r in responsibilities_W loop -- w is for web
942: select count(*)
943: INTO l_function_count
944: from
945: fnd_responsibility_vl a,
946: fnd_menu_entries_vl b,
947: fnd_form_functions_vl c
948: where a.responsibility_id=r.responsibility_id
949: and a.menu_id=b.menu_id

Line 965: FROM fnd_responsibility_vl

961: INTO l_menu_count
962: FROM fnd_menu_entries_vl c
963: WHERE prompt IS NOT NULL
964: and menu_id=(SELECT menu_id
965: FROM fnd_responsibility_vl
966: WHERE responsibility_id = r.responsibility_id
967: AND APPLICATION_ID = r.responsibility_application_id)
968: AND nvl(c.FUNCTION_ID,-1) not in -- menu exclusion support 1911095 mputman
969: (select ACTION_ID

Line 987: fnd_responsibility_vl a,

983:
984: SELECT c.function_id, nvl(b.prompt,c.user_function_name) prompt,c.TYPE,a.menu_id
985: INTO l_function_code, l_menu_prompt, l_function_type, l_menu_id
986: from
987: fnd_responsibility_vl a,
988: fnd_menu_entries_vl b,
989: fnd_form_functions_vl c
990: where a.responsibility_id=r.responsibility_id
991: and a.menu_id=b.menu_id