DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_ORG_F

Line 1346: FROM ben_popl_org_f cpo,

1342: if the program selection is limited based on person's org id. */
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

Line 1386: FROM ben_popl_org_f cpo,

1382: if the program selection is limited based on person's org id. */
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

Line 1546: FROM ben_popl_org_f cpo,

1542: OR p_asnd_lf_evt_dt IS NULL)
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