APPS.BEN_EXT_THREAD dependencies on BEN_POPL_ORG_ROLE_F

Line 668: ben_popl_org_role_f b

664:
665: cursor c_plcy (l_pl_id Number , l_typ_cd varchar2) is
666: select a.plcy_r_grp
667: from ben_popl_org_f a,
668: ben_popl_org_role_f b
669: where a.pl_id = l_pl_id
670: and a.plcy_r_grp is not null
671: and a.popl_org_id = b.popl_org_id
672: and b.org_role_typ_cd = l_typ_cd

Line 690: ben_popl_org_role_f b

686:
687: cursor c_custid (l_pl_id Number , l_typ_cd varchar2) is
688: select a.cstmr_num
689: from ben_popl_org_f a,
690: ben_popl_org_role_f b
691: where a.pl_id = l_pl_id
692: and a.cstmr_num is not null
693: and a.popl_org_id = b.popl_org_id
694: and b.org_role_typ_cd = l_typ_cd

Line 703: ben_popl_org_role_f b

699:
700: cursor c_rolname (l_pl_id Number , l_typ_cd varchar2) is
701: select b.name
702: from ben_popl_org_f a,
703: ben_popl_org_role_f b
704: where a.pl_id = l_pl_id
705: and b.name is not null
706: and b.org_role_typ_cd = l_typ_cd
707: and a.popl_org_id = b.popl_org_id