APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on BEN_CWB_PERSON_GROUPS

Line 140: from ben_cwb_person_groups groups

136: OR
137: ((v_target_pop = 'MNS')
138: AND (hrchy.lvl_num = 0)
139: AND EXISTS(select groups.submit_cd
140: from ben_cwb_person_groups groups
141: where groups.group_per_in_ler_id = pil.per_in_ler_id
142: and groups.group_pl_id = pil.group_pl_id
143: and groups.group_oipl_id = -1
144: and groups.submit_cd = 'NS'))

Line 149: from ben_cwb_person_groups groups

145: OR
146: ((v_target_pop = 'MOB')
147: AND (hrchy.lvl_num = 0)
148: AND EXISTS(select groups.submit_cd
149: from ben_cwb_person_groups groups
150: where groups.group_per_in_ler_id = pil.per_in_ler_id
151: and groups.group_pl_id = pil.group_pl_id
152: and groups.group_oipl_id = -1
153: and groups.submit_cd = 'SU'

Line 159: from ben_cwb_person_groups groups

155: OR
156: ((v_target_pop = 'MWA')
157: AND (hrchy.lvl_num = 0)
158: AND EXISTS(select groups.approval_cd
159: from ben_cwb_person_groups groups
160: where groups.group_per_in_ler_id = pil.per_in_ler_id
161: and groups.group_pl_id = pil.group_pl_id
162: and groups.group_oipl_id = -1
163: and nvl(groups.approval_cd,'NULL') <> 'AP'))

Line 168: from ben_cwb_person_groups groups

164: OR
165: ((v_target_pop = 'MWB')
166: AND (hrchy.lvl_num = 0)
167: AND EXISTS(select groups.submit_cd
168: from ben_cwb_person_groups groups
169: where groups.group_per_in_ler_id = pil.per_in_ler_id
170: and groups.group_pl_id = pil.group_pl_id
171: and groups.group_oipl_id = -1
172: and (groups.dist_bdgt_val is not null

Line 214: from ben_cwb_person_groups gr

210: AND
211: (
212: ((v_req_acc_lvl = 'AL')
213: AND EXISTS (select gr.access_cd
214: from ben_cwb_person_groups gr
215: , ben_cwb_group_hrchy hr
216: where hr.emp_per_in_ler_id = pil.per_in_ler_id
217: and hr.lvl_num = 0
218: and gr.group_per_in_ler_id = hr.emp_per_in_ler_id

Line 225: from ben_cwb_person_groups gr

221: and gr.access_cd IN ('UP','RO','NA')))
222: OR
223: ((v_req_acc_lvl = 'FR')
224: AND EXISTS (select gr.access_cd
225: from ben_cwb_person_groups gr
226: , ben_cwb_group_hrchy hr
227: where hr.emp_per_in_ler_id = pil.per_in_ler_id
228: and hr.lvl_num = 0
229: and gr.group_per_in_ler_id = pil.per_in_ler_id

Line 236: from ben_cwb_person_groups gr

232: and gr.access_cd IN ('UP','RO')))
233: OR
234: ((v_req_acc_lvl = 'FU')
235: AND EXISTS (select gr.access_cd
236: from ben_cwb_person_groups gr
237: , ben_cwb_group_hrchy hr
238: where hr.emp_per_in_ler_id = pil.per_in_ler_id
239: and hr.lvl_num = 0
240: and gr.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 247: from ben_cwb_person_groups gr

243: and gr.access_cd IN ('UP')))
244: OR
245: ((v_req_acc_lvl = 'NA')
246: AND EXISTS (select gr.access_cd
247: from ben_cwb_person_groups gr
248: , ben_cwb_group_hrchy hr
249: where hr.emp_per_in_ler_id = pil.per_in_ler_id
250: and hr.lvl_num = 0
251: and gr.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 258: from ben_cwb_person_groups gr

254: and gr.access_cd IN ('NA')))
255: OR
256: ((v_req_acc_lvl = 'RO')
257: AND EXISTS (select gr.access_cd
258: from ben_cwb_person_groups gr
259: , ben_cwb_group_hrchy hr
260: where hr.emp_per_in_ler_id = pil.per_in_ler_id
261: and hr.lvl_num = 0
262: and gr.group_per_in_ler_id = hrchy.emp_per_in_ler_id