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
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
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