APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on ASG_USER

Line 122: FROM asg_user_pub_resps pubresp

118:
119: CURSOR l_omfs_palm_resources_csr is
120: --R12 For multiple responsibility
121: select usr.user_id, usr.user_name
122: FROM asg_user_pub_resps pubresp
123: , asg_user usr
124: WHERE usr.enabled = 'Y'
125: AND pubresp.user_name = usr.user_name
126: AND usr.user_id=usr.owner_id

Line 123: , asg_user usr

119: CURSOR l_omfs_palm_resources_csr is
120: --R12 For multiple responsibility
121: select usr.user_id, usr.user_name
122: FROM asg_user_pub_resps pubresp
123: , asg_user usr
124: WHERE usr.enabled = 'Y'
125: AND pubresp.user_name = usr.user_name
126: AND usr.user_id=usr.owner_id
127: AND pubresp.pub_name ='SERVICEP';

Line 142: FOR rec IN (SELECT USER_ID,RESPONSIBILITY_ID FROM ASG_USER WHERE ENABLED='Y')

138: OPEN l_last_run_date_csr;
139: FETCH l_last_run_date_csr INTO l_run_date;
140: CLOSE l_last_run_date_csr;
141:
142: FOR rec IN (SELECT USER_ID,RESPONSIBILITY_ID FROM ASG_USER WHERE ENABLED='Y')
143: LOOP
144: Refresh_Acc_upd_Del(rec.USER_ID,rec.RESPONSIBILITY_ID,l_run_date);
145: Refresh_acc_ins(rec.USER_ID,rec.RESPONSIBILITY_ID);
146: END LOOP;