DBA Data[Home] [Help]

APPS.IGS_EN_GEN_017 dependencies on FND_USER_RESP_GROUPS

Line 1137: CURSOR c_fnd_user_dtls (cp_user_id fnd_user_resp_groups.user_id%TYPE) IS

1133:
1134: /*
1135: cursor to fetch the RESP_ID and RESP_APPL_ID against the user_id
1136: */
1137: CURSOR c_fnd_user_dtls (cp_user_id fnd_user_resp_groups.user_id%TYPE) IS
1138: SELECT responsibility_id,
1139: responsibility_application_id,
1140: security_group_id
1141: FROM fnd_user_resp_groups

Line 1141: FROM fnd_user_resp_groups

1137: CURSOR c_fnd_user_dtls (cp_user_id fnd_user_resp_groups.user_id%TYPE) IS
1138: SELECT responsibility_id,
1139: responsibility_application_id,
1140: security_group_id
1141: FROM fnd_user_resp_groups
1142: WHERE user_id = cp_user_id
1143: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1144: rec_fnd_user_dtls c_fnd_user_dtls%ROWTYPE;
1145: