DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_ORG_ROLE_F

Line 1362: ben_popl_org_role_f cpr

1358: AND (
1359: EXISTS
1360: (SELECT NULL
1361: FROM ben_popl_org_f cpo,
1362: ben_popl_org_role_f cpr
1363: WHERE cpo.pgm_id = pgm.pgm_id
1364: AND p_effective_date BETWEEN cpo.effective_start_date
1365: AND cpo.effective_end_date
1366: AND cpo.popl_org_id = cpr.popl_org_id

Line 1402: ben_popl_org_role_f cpr

1398: AND (
1399: EXISTS
1400: (SELECT NULL
1401: FROM ben_popl_org_f cpo,
1402: ben_popl_org_role_f cpr
1403: WHERE cpo.pgm_id = pgm.pgm_id
1404: AND p_effective_date BETWEEN cpo.effective_start_date
1405: AND cpo.effective_end_date
1406: AND cpo.popl_org_id = cpr.popl_org_id

Line 1562: ben_popl_org_role_f cpr

1558: AND (
1559: EXISTS
1560: (SELECT NULL
1561: FROM ben_popl_org_f cpo,
1562: ben_popl_org_role_f cpr
1563: WHERE cpo.pl_id = pln.pl_id
1564: AND p_effective_date BETWEEN cpo.effective_start_date
1565: AND cpo.effective_end_date
1566: AND cpo.popl_org_id = cpr.popl_org_id