APPS.CSM_UTIL_PKG dependencies on ASG_USER_PUB_RESPS

Line 165: FROM asg_user_pub_resps pubresp

161:
162: CURSOR l_omfs_palm_users_csr
163: IS
164: SELECT usr.USER_ID
165: FROM asg_user_pub_resps pubresp
166: , asg_user usr
167: WHERE usr.enabled = 'Y'
168: AND pubresp.user_name = usr.user_name
169: AND pubresp.pub_name ='SERVICEP';

Line 174: FROM asg_user_pub_resps pubresp

170: --Cursor when data routed to owner profile is set
171: CURSOR l_route_omfs_palm_users_csr
172: IS
173: SELECT usr.USER_ID
174: FROM asg_user_pub_resps pubresp
175: , asg_user usr
176: WHERE usr.enabled = 'Y'
177: AND pubresp.user_name = usr.user_name
178: AND pubresp.pub_name ='SERVICEP'

Line 209: FROM asg_user_pub_resps pubresp

205:
206: CURSOR l_omfs_palm_resources_csr
207: IS
208: SELECT usr.resource_id
209: FROM asg_user_pub_resps pubresp
210: , asg_user usr
211: WHERE usr.enabled = 'Y'
212: AND pubresp.user_name = usr.user_name
213: AND pubresp.pub_name = 'SERVICEP';

Line 218: FROM asg_user_pub_resps pubresp

214:
215: CURSOR l_route_omfs_palm_res_csr
216: IS
217: SELECT usr.resource_id
218: FROM asg_user_pub_resps pubresp
219: , asg_user usr
220: WHERE usr.enabled = 'Y'
221: AND pubresp.user_name = usr.user_name
222: AND pubresp.pub_name = 'SERVICEP'

Line 728: FROM asg_user_pub_resps pubresp

724: IS
725: CURSOR l_is_palm_resource_csr(p_resource_id IN jtf_rs_resource_extns.resource_id%TYPE)
726: IS--R12 on multiple responsibility
727: SELECT 1
728: FROM asg_user_pub_resps pubresp
729: , asg_user usr
730: WHERE usr.enabled = 'Y'
731: AND pubresp.user_name = usr.user_name
732: AND pubresp.pub_name = 'SERVICEP'

Line 778: FROM asg_user_pub_resps pubresp

774: IS
775: CURSOR l_responsibilities_csr (b_user_id NUMBER)--R12 For multiple responsibility
776: IS
777: SELECT 1
778: FROM asg_user_pub_resps pubresp
779: , asg_user usr
780: WHERE usr.enabled = 'Y'
781: AND pubresp.user_name = usr.user_name
782: AND pubresp.pub_name = 'SERVICEP'

Line 832: FROM asg_user_pub_resps pubresp

828:
829: CURSOR l_tl_omfs_palm_users_csr is
830: --R12 For multiple responsibility
831: select usr.USER_ID
832: FROM asg_user_pub_resps pubresp
833: , asg_user usr
834: WHERE usr.LANGUAGE = p_language
835: AND usr.enabled = 'Y'
836: AND pubresp.user_name = usr.user_name

Line 842: FROM asg_user_pub_resps pubresp

838:
839: CURSOR l_route_tl_omfs_palm_users_csr is
840: --R12 For multiple responsibility
841: select usr.USER_ID
842: FROM asg_user_pub_resps pubresp
843: , asg_user usr
844: WHERE usr.LANGUAGE = p_language
845: AND usr.enabled = 'Y'
846: AND pubresp.user_name = usr.user_name

Line 876: FROM asg_user_pub_resps pubresp

872:
873: CURSOR l_tl_omfs_palm_resources_csr is
874: --R12 For multiple responsibility
875: select usr.RESOURCE_ID
876: FROM asg_user_pub_resps pubresp
877: , asg_user usr
878: WHERE usr.LANGUAGE = p_language
879: AND usr.enabled = 'Y'
880: AND pubresp.user_name = usr.user_name

Line 886: FROM asg_user_pub_resps pubresp

882:
883: CURSOR l_route_tl_omfs_palm_res_csr is
884: --R12 For multiple responsibility
885: select usr.RESOURCE_ID
886: FROM asg_user_pub_resps pubresp
887: , asg_user usr
888: WHERE usr.LANGUAGE = p_language
889: AND usr.enabled = 'Y'
890: AND pubresp.user_name = usr.user_name