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 877: from fnd_application

873: from fnd_user
874: where user_name = X_USER_NAME;
875:
876: select application_id into app_id
877: from fnd_application
878: where application_short_name = X_APP_SHORT_NAME;
879:
880: select responsibility_id into resp_id
881: from fnd_responsibility

Line 1126: from fnd_application

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

Line 1469: fnd_application app,

1465: furgo.last_update_date,
1466: furgo.last_update_login
1467: from fnd_user_resp_groups_old furgo,
1468: fnd_user fu,
1469: fnd_application app,
1470: fnd_responsibility resp,
1471: fnd_security_groups secgrp
1472: where furgo.user_id = fu.user_id
1473: and furgo.responsibility_id = resp.responsibility_id