APPS.BEN_EXT_THREAD dependencies on BEN_POPL_ORG_F

Line 667: from ben_popl_org_f a,

663: where organization_id = p_bg_id ;
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

Line 680: from ben_popl_org_f a

676: and b.effective_end_date;
677:
678: cursor c_plplcy (l_pl_id Number) is
679: select a.plcy_r_grp
680: from ben_popl_org_f a
681: where a.pl_id = l_pl_id
682: and a.plcy_r_grp is not null
683: and p_effective_date between a.effective_start_date
684: and a.effective_end_date ;

Line 689: from ben_popl_org_f a,

685:
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

Line 702: from ben_popl_org_f a,

698: and b.effective_end_date;
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