APPS.BIS_RL_PKG dependencies on FND_RESPONSIBILITY_VL

Line 487: from fnd_responsibility_vl

483: menu_id
484: into l_responsibility_name,
485: l_description,
486: l_menu_id
487: from fnd_responsibility_vl
488: where responsibility_id = p_object.responsibility_id
489: and application_id = p_object.resp_appl_id
490: -- remove version check to show all resp
491: --and version = 'W'

Line 1187: FROM fnd_responsibility_vl a,

1183: SELECT b.responsibility_application_id,
1184: b.security_group_id
1185: INTO l_resp_appl_id,
1186: l_security_group_id
1187: FROM fnd_responsibility_vl a,
1188: FND_USER_RESP_GROUPS b
1189: WHERE a.responsibility_id = p_resp_id
1190: AND b.user_id = p_user_id
1191: AND b.RESPONSIBILITY_id = a.responsibility_id

Line 1309: from fnd_responsibility_vl a,

1305: select b.responsibility_application_id,
1306: b.security_group_id
1307: into l_resp_appl_id,
1308: l_security_group_id
1309: from fnd_responsibility_vl a,
1310: FND_USER_RESP_GROUPS b
1311: where a.responsibility_id = p_resp_id
1312: and b.user_id = p_user_id
1313: and b.RESPONSIBILITY_id = a.responsibility_id

Line 1348: fnd_responsibility_vl a,

1344: b.responsibility_application_id,
1345: b.security_group_id,
1346: fsg.SECURITY_GROUP_NAME
1347: from FND_SECURITY_GROUPS_VL fsg,
1348: fnd_responsibility_vl a,
1349: FND_USER_RESP_GROUPS b
1350: where b.user_id = p_user_id
1351: and b.start_date <= sysdate
1352: and (b.end_date is null or b.end_date > sysdate)

Line 1393: p_resp_sql := 'select responsibility_id, responsibility_name from fnd_responsibility_vl where responsibility_id in ('

1389: end if;
1390: end loop;
1391:
1392: /*
1393: p_resp_sql := 'select responsibility_id, responsibility_name from fnd_responsibility_vl where responsibility_id in ('
1394: || l_resp_criteria || ') order by responsibility_name ';
1395: */
1396: --bugfix 3857066
1397: p_resp_sql := 'select a.responsibility_id, a.responsibility_name from fnd_responsibility_vl a, fnd_user_resp_groups b

Line 1397: p_resp_sql := 'select a.responsibility_id, a.responsibility_name from fnd_responsibility_vl a, fnd_user_resp_groups b

1393: p_resp_sql := 'select responsibility_id, responsibility_name from fnd_responsibility_vl where responsibility_id in ('
1394: || l_resp_criteria || ') order by responsibility_name ';
1395: */
1396: --bugfix 3857066
1397: p_resp_sql := 'select a.responsibility_id, a.responsibility_name from fnd_responsibility_vl a, fnd_user_resp_groups b
1398: where a.responsibility_id in ('|| l_resp_criteria || ')
1399: and b.user_id = '|| p_user_id ||' and b.RESPONSIBILITY_id = a.responsibility_id and b.responsibility_application_id = a.application_id order by responsibility_name ';
1400:
1401: end getRespSQLWrapper;

Line 2261: fnd_responsibility_vl a,

2257: l_object.resp_appl_id,
2258: l_object.security_group_id,
2259: l_menu_id
2260: from FND_SECURITY_GROUPS_VL fsg,
2261: fnd_responsibility_vl a,
2262: FND_USER_RESP_GROUPS b
2263: where a.responsibility_id = p_resp_id
2264: and b.user_id = p_user_id
2265: and b.start_date <= sysdate

Line 2460: fnd_responsibility_vl a,

2456: l_object.resp_appl_id,
2457: l_object.security_group_id,
2458: l_menu_id
2459: from FND_SECURITY_GROUPS_VL fsg,
2460: fnd_responsibility_vl a,
2461: FND_USER_RESP_GROUPS b
2462: where a.responsibility_id = l_id
2463: and b.user_id = p_user_id
2464: and b.start_date <= sysdate

Line 2678: fnd_responsibility_vl a,

2674: l_object.resp_appl_id,
2675: l_object.security_group_id,
2676: l_menu_id
2677: from FND_SECURITY_GROUPS_VL fsg,
2678: fnd_responsibility_vl a,
2679: FND_USER_RESP_GROUPS b
2680: where a.responsibility_id = p_resp_id
2681: and b.user_id = p_user_id
2682: and b.start_date <= sysdate

Line 2876: fnd_responsibility_vl a,

2872: l_object.resp_appl_id,
2873: l_object.security_group_id,
2874: l_menu_id
2875: from FND_SECURITY_GROUPS_VL fsg,
2876: fnd_responsibility_vl a,
2877: FND_USER_RESP_GROUPS b
2878: where a.responsibility_id = p_resp_id
2879: and b.user_id = p_user_id
2880: and b.start_date <= sysdate