APPS.FND_USER_RESP_GROUPS_API dependencies on FND_APPLICATION

Line 123: from fnd_application

119: where security_group_id = x_secgrp_id;
120:
121: select application_short_name
122: into appsname
123: from fnd_application
124: where application_id = x_resp_appl_id;
125:
126: select responsibility_key
127: into respkey

Line 500: from fnd_application

496:
497:
498: select application_short_name
499: into appsname
500: from fnd_application
501: where application_id = responsibility_application_id;
502:
503:
504: /* Check whether there already is a direct row; if so, */

Line 688: from fnd_application

684:
685:
686: select application_short_name
687: into appsname
688: from fnd_application
689: where application_id = responsibility_application_id;
690:
691:
692: /* Check whether there already is a direct row to update; if not, */

Line 873: from fnd_application

869: from fnd_user
870: where user_name = X_USER_NAME;
871:
872: select application_id into app_id
873: from fnd_application
874: where application_short_name = X_APP_SHORT_NAME;
875:
876: select responsibility_id into resp_id
877: from fnd_responsibility

Line 1122: from fnd_application

1118: /* Get the application short name for role name */
1119: begin
1120: select application_short_name
1121: into applsname
1122: from fnd_application
1123: where application_id = appid;
1124:
1125: role_name := fnd_user_resp_groups_api.role_name_from_resp_name(
1126: respkey, applsname, secgrpkey);

Line 1465: fnd_application app,

1461: furgo.last_update_date,
1462: furgo.last_update_login
1463: from fnd_user_resp_groups_old furgo,
1464: fnd_user fu,
1465: fnd_application app,
1466: fnd_responsibility resp,
1467: fnd_security_groups secgrp
1468: where furgo.user_id = fu.user_id
1469: and furgo.responsibility_id = resp.responsibility_id