APPS.CSM_UTIL_PKG dependencies on FND_USER_RESP_GROUPS

Line 397: FROM FND_USER_RESP_GROUPS

393: RULE_TABLE RULE_TABLE_TYPE;
394:
395: CURSOR C_USER_RESP ( p_user_id NUMBER ) IS
396: SELECT RESPONSIBILITY_ID
397: FROM FND_USER_RESP_GROUPS
398: WHERE NVL( START_DATE , SYSDATE) <= SYSDATE
399: AND NVL( END_DATE , SYSDATE) >= SYSDATE
400: AND USER_ID = p_user_id;
401:

Line 740: fnd_user_resp_groups fnd_user_resp,

736: IS
737: select fnd_user_resp.user_id
738: from asg_pub_responsibility asg_resp,
739: asg_pub,
740: fnd_user_resp_groups fnd_user_resp,
741: fnd_application fnd_app,
742: jtf_rs_resource_extns res
743: where asg_resp.pub_id = asg_pub.pub_id
744: and asg_pub.name = 'SERVICEP'

Line 790: fnd_user_resp_groups fnd_user_resp,

786: /* cursor l_responsibilities_csr (b_user_id number) is
787: select fnd_user_resp.user_id
788: from asg_pub_responsibility asg_resp,
789: asg_pub,
790: fnd_user_resp_groups fnd_user_resp,
791: fnd_application fnd_app
792: where asg_resp.pub_id = asg_pub.pub_id
793: and asg_pub.name = 'SERVICEP'
794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id