APPS.BEN_CPR_BUS dependencies on BEN_POPL_ORG_F

Line 117: from ben_popl_org_f pof

113:
114: l_plnip varchar2(1);
115: cursor c1 is
116: select 'x'
117: from ben_popl_org_f pof
118: ,ben_pl_f pln
119: Where pof.popl_org_id = p_popl_org_id
120: and p_effective_date between pof.effective_start_date
121: and pof.effective_end_date

Line 214: l_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE; -- UTF8 varchar2(30);

210: l_proc varchar2(72) := g_package|| ' chk_uniq_org_role_typ';
211:
212: l_pl_id number;
213: l_num_of_pcps number;
214: l_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE; -- UTF8 varchar2(30);
215:
216: -- get data for this popl-org
217: cursor get_grp_and_pl_id is
218: select cpo.pl_id, cpo.plcy_r_grp

Line 219: from ben_popl_org_f cpo

215:
216: -- get data for this popl-org
217: cursor get_grp_and_pl_id is
218: select cpo.pl_id, cpo.plcy_r_grp
219: from ben_popl_org_f cpo
220: where cpo.popl_org_id = p_popl_org_id
221: and cpo.business_group_id = p_business_group_id
222: and p_effective_date between
223: cpo.effective_start_date and cpo.effective_end_date;

Line 228: from ben_popl_org_f cpo

224:
225: -- how many pcp role rows exist for this plan?
226: cursor num_of_pcps (p_pl_id number) is
227: select count('x')
228: from ben_popl_org_f cpo
229: ,ben_popl_org_role_f cpr
230: Where cpo.popl_org_id = cpr.popl_org_id
231: and cpo.pl_id = p_pl_id
232: and cpo.business_group_id = p_business_group_id