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
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: