APPS.EGO_ODI_PUB dependencies on FND_RESPONSIBILITY

Line 717: from FND_RESPONSIBILITY

713:
714: --retrieving responsibility id from responsibility name
715: Select responsibility_id
716: into x_resp_id
717: from FND_RESPONSIBILITY
718: where responsibility_key = p_resp_name;
719:
720: RETURN TRUE;
721:

Line 1053: from FND_RESPONSIBILITY

1049:
1050: --retrieving responsibility_id
1051: Select application_id
1052: into l_application_id
1053: from FND_RESPONSIBILITY
1054: where responsibility_id = l_responsibility_id;
1055: */
1056:
1057:

Line 2585: from FND_RESPONSIBILITY

2581:
2582: --retrieving responsibility name
2583: select responsibility_key
2584: into l_responsibility_name
2585: from FND_RESPONSIBILITY
2586: where responsibility_id = l_responsibility_id;
2587:
2588: --inserting responsibility name
2589: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

Line 2609: from FND_RESPONSIBILITY

2605:
2606: --retrieving application_id
2607: Select application_id
2608: into l_application_id
2609: from FND_RESPONSIBILITY
2610: where responsibility_id = l_responsibility_id;
2611:
2612: --retrieving responsibility_appl_name
2613: select APPLICATION_SHORT_NAME

Line 6911: FROM fnd_user_resp_groups_direct furgd, fnd_responsibility fr

6907: CURSOR Cur_priv(cp_user_id NUMBER,
6908: cp_resp_id NUMBER)
6909: IS
6910: SELECT Count(furgd.responsibility_id) val
6911: FROM fnd_user_resp_groups_direct furgd, fnd_responsibility fr
6912: WHERE furgd.responsibility_id=fr.responsibility_id
6913: AND fr.menu_id IN
6914: (SELECT menu_id
6915: FROM fnd_menu_entries

Line 6972: FROM FND_RESPONSIBILITY

6968:
6969: --retrieving responsability_id
6970: SELECT application_id
6971: INTO l_application_id
6972: FROM FND_RESPONSIBILITY
6973: WHERE responsibility_id = l_resp_id;
6974:
6975:
6976: /*Get username for passed in user id*/

Line 6991: FROM fnd_responsibility_vl

6987:
6988: /*Get respId for passed in responsibility name*/
6989: BEGIN
6990: SELECT responsibility_name INTO l_resp_name
6991: FROM fnd_responsibility_vl
6992: WHERE application_id = l_application_id
6993: AND responsibility_id =l_resp_id ;
6994: EXCEPTION
6995: WHEN No_Data_Found THEN

Line 7038: FROM fnd_responsibility_vl

7034:
7035: /*Get respId for passed in responsibility name*/
7036: BEGIN
7037: SELECT responsibility_id,responsibility_name INTO l_resp_id,l_resp_name
7038: FROM fnd_responsibility_vl
7039: WHERE application_id = l_application_id
7040: AND responsibility_key=l_resp_key;
7041: EXCEPTION
7042: WHEN No_Data_Found THEN