DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_ORG_ROLE_F

Line 1347: ben_popl_org_role_f cpr

1343: AND (
1344: EXISTS
1345: (SELECT NULL
1346: FROM ben_popl_org_f cpo,
1347: ben_popl_org_role_f cpr
1348: WHERE cpo.pgm_id = pgm.pgm_id
1349: AND p_effective_date BETWEEN cpo.effective_start_date
1350: AND cpo.effective_end_date
1351: AND cpo.popl_org_id = cpr.popl_org_id

Line 1387: ben_popl_org_role_f cpr

1383: AND (
1384: EXISTS
1385: (SELECT NULL
1386: FROM ben_popl_org_f cpo,
1387: ben_popl_org_role_f cpr
1388: WHERE cpo.pgm_id = pgm.pgm_id
1389: AND p_effective_date BETWEEN cpo.effective_start_date
1390: AND cpo.effective_end_date
1391: AND cpo.popl_org_id = cpr.popl_org_id

Line 1547: ben_popl_org_role_f cpr

1543: AND (
1544: EXISTS
1545: (SELECT NULL
1546: FROM ben_popl_org_f cpo,
1547: ben_popl_org_role_f cpr
1548: WHERE cpo.pl_id = pln.pl_id
1549: AND p_effective_date BETWEEN cpo.effective_start_date
1550: AND cpo.effective_end_date
1551: AND cpo.popl_org_id = cpr.popl_org_id