APPS.BSC_SCORECARD_PUB dependencies on FND_GRANTS

Line 920: FROM FND_GRANTS GNT,

916: WHERE function_name= p_user_access;
917:
918: SELECT COUNT(GNT.grant_guid)
919: INTO l_count
920: FROM FND_GRANTS GNT,
921: FND_OBJECTS b,
922: FND_MENUS m,
923: FND_MENU_ENTRIES e
924: WHERE GNT.PROGRAM_NAME = 'BSC_PMD_GRANTS'

Line 982: FROM FND_GRANTS GNT,

978: WHERE function_name= p_user_access;
979:
980: SELECT COUNT(GNT.grant_guid)
981: INTO l_count
982: FROM FND_GRANTS GNT,
983: FND_OBJECTS b,
984: FND_MENUS m,
985: FND_MENU_ENTRIES e
986: WHERE GNT.PROGRAM_NAME = 'BSC_PMD_GRANTS'

Line 1127: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;

1123: ,x_chd_tabname_list OUT NOCOPY VARCHAR2
1124: ) IS
1125:
1126: l_grant_guids VARCHAR2(32000);
1127: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
1128: l_tab_id FND_GRANTS.INSTANCE_PK1_VALUE%TYPE;
1129: l_single_grant_guid FND_GRANTS.GRANT_GUID%TYPE;
1130: l_tablist_name VARCHAR2(4000);
1131: l_check_children VARCHAR2(4000);

Line 1128: l_tab_id FND_GRANTS.INSTANCE_PK1_VALUE%TYPE;

1124: ) IS
1125:
1126: l_grant_guids VARCHAR2(32000);
1127: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
1128: l_tab_id FND_GRANTS.INSTANCE_PK1_VALUE%TYPE;
1129: l_single_grant_guid FND_GRANTS.GRANT_GUID%TYPE;
1130: l_tablist_name VARCHAR2(4000);
1131: l_check_children VARCHAR2(4000);
1132: l_check_child BSC_TABS_VL.NAME%TYPE;

Line 1129: l_single_grant_guid FND_GRANTS.GRANT_GUID%TYPE;

1125:
1126: l_grant_guids VARCHAR2(32000);
1127: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
1128: l_tab_id FND_GRANTS.INSTANCE_PK1_VALUE%TYPE;
1129: l_single_grant_guid FND_GRANTS.GRANT_GUID%TYPE;
1130: l_tablist_name VARCHAR2(4000);
1131: l_check_children VARCHAR2(4000);
1132: l_check_child BSC_TABS_VL.NAME%TYPE;
1133:

Line 1142: FROM fnd_grants

1138: , p_grant_uid => l_single_grant_guid)) LOOP
1139:
1140: SELECT grantee_key,instance_pk1_value
1141: INTO l_grantee_key, l_tab_id
1142: FROM fnd_grants
1143: WHERE grant_guid = l_single_grant_guid;
1144:
1145: l_check_children := Chk_Child_Scd_Has_Access(l_tab_id,l_grantee_key);
1146: