DBA Data[Home] [Help]

APPS.BEN_EXT_ELIG dependencies on BEN_POPL_ORG_F

Line 1352: ben_popl_org_f cpo

1348: cursor c_cbradm_pl (p_pl_id number) is
1349: select cpr.name admin_name,
1350: cpo.organization_id
1351: from ben_popl_org_role_f cpr,
1352: ben_popl_org_f cpo
1353: where
1354: cpo.pl_id = p_pl_id
1355: AND cpr.popl_org_id = cpo.popl_org_id
1356: and cpr.org_role_typ_cd = 'ADM'

Line 1366: ben_popl_org_f cpo

1362: cursor c_cbradm_pgm (p_pgm_id number) is
1363: select cpr.name admin_name,
1364: cpo.organization_id
1365: from ben_popl_org_role_f cpr,
1366: ben_popl_org_f cpo
1367: where
1368: cpo.pgm_id = p_pgm_id
1369: AND cpr.popl_org_id = cpo.popl_org_id
1370: and cpr.org_role_typ_cd = 'ADM'