DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_ORG_F

Line 1361: FROM ben_popl_org_f cpo,

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

Line 1401: FROM ben_popl_org_f cpo,

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

Line 1561: FROM ben_popl_org_f cpo,

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