APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_YR_PERD

Line 1043: -- ,ben_yr_perd yrp

1039: pgm.drvbl_fctr_apls_rts_flag,
1040: pgm.trk_inelig_per_flag
1041: FROM -- ben_popl_yr_perd cpy
1042: ben_pgm_f pgm
1043: -- ,ben_yr_perd yrp
1044: WHERE pgm.business_group_id = p_business_group_id
1045: AND pgm.pgm_id = NVL(p_pgm_id, pgm.pgm_id)
1046: AND pgm.pgm_stat_cd = 'A'
1047: AND (

Line 1059: from ben_yr_perd yrp,

1055: AND pgm.effective_end_date
1056: AND p_mode not in ('D','I')
1057: AND (p_mode = 'G' or
1058: exists (select null
1059: from ben_yr_perd yrp,
1060: ben_popl_yr_perd cpy
1061: where cpy.pgm_id = pgm.pgm_id
1062: AND cpy.yr_perd_id = yrp.yr_perd_id
1063: AND cpy.business_group_id = pgm.business_group_id

Line 1384: ,ben_yr_perd yrp

1380: pgm.drvbl_fctr_apls_rts_flag,
1381: pgm.trk_inelig_per_flag
1382: FROM ben_popl_yr_perd cpy
1383: ,ben_pgm_f pgm
1384: ,ben_yr_perd yrp
1385: WHERE pgm.business_group_id = p_business_group_id
1386: AND pgm.pgm_stat_cd = 'A'
1387: AND pgm.pgm_typ_cd LIKE 'COBRA%'
1388: AND p_effective_date BETWEEN pgm.effective_start_date

Line 1426: -- ben_yr_perd yrp,

1422: pln.drvbl_fctr_apls_rts_flag,
1423: pln.trk_inelig_per_flag
1424: FROM ben_pl_f pln,
1425: ben_pl_typ_f ptp
1426: -- ben_yr_perd yrp,
1427: -- ben_popl_yr_perd cpy
1428: WHERE pln.business_group_id = p_business_group_id
1429: AND p_effective_date BETWEEN pln.effective_start_date
1430: AND pln.effective_end_date

Line 1443: from ben_yr_perd yrp,

1439: /* Make sure that the plan is not in the plip table.
1440: or may not have been stated by the user. */
1441: AND (p_mode IN ('P','G','D') or -- ICM
1442: exists (select null
1443: from ben_yr_perd yrp,
1444: ben_popl_yr_perd cpy
1445: where cpy.pl_id = pln.pl_id
1446: AND cpy.yr_perd_id = yrp.yr_perd_id
1447: AND cpy.business_group_id = pln.business_group_id

Line 1587: -- ben_yr_perd yrp,

1583: pln.trk_inelig_per_flag
1584: FROM ben_pl_f pln,
1585: ben_pl_typ_f ptp,
1586: -- ben_popl_yr_perd cpy,
1587: -- ben_yr_perd yrp,
1588: ben_plip_f plp,
1589: ben_ptip_f ctp
1590: WHERE pln.business_group_id = p_business_group_id
1591: AND pln.pl_id = plp.pl_id

Line 1608: from ben_yr_perd yrp,

1604: AND plp.effective_end_date
1605:
1606: AND (p_mode = 'G' or
1607: exists (select null
1608: from ben_yr_perd yrp,
1609: ben_popl_yr_perd cpy
1610: where cpy.pl_id = pln.pl_id
1611: AND cpy.yr_perd_id = yrp.yr_perd_id
1612: AND cpy.business_group_id = pln.business_group_id

Line 1633: -- ,ben_yr_perd yrp

1629: cop.trk_inelig_per_flag
1630: FROM ben_oipl_f cop
1631: ,ben_opt_f opt
1632: -- ,ben_popl_yr_perd cpy
1633: -- ,ben_yr_perd yrp
1634: ,ben_pl_f pln
1635: WHERE cop.business_group_id = p_business_group_id
1636: AND p_effective_date BETWEEN cop.effective_start_date
1637: AND cop.effective_end_date

Line 1652: from ben_yr_perd yrp,

1648: AND opt.effective_end_date
1649:
1650: AND (p_mode in ('G','D') or
1651: exists (select null
1652: from ben_yr_perd yrp,
1653: ben_popl_yr_perd cpy
1654: where cpy.pl_id = cop.pl_id
1655: AND cpy.yr_perd_id = yrp.yr_perd_id
1656: AND cpy.business_group_id = cop.business_group_id

Line 1936: l_tabname_set(11) := 'ben_yr_perd';

1932: l_tabname_set(8) := 'ben_prtn_elig_prfl_f';
1933: l_tabname_set(9) := 'ben_eligy_prfl_f';
1934: --
1935: l_tabname_set(10) := 'ben_popl_yr_perd';
1936: l_tabname_set(11) := 'ben_yr_perd';
1937: l_tabname_set(12) := 'ben_rptg_grp';
1938: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1939: --
1940: l_tabname_set(10) := 'ben_popl_yr_perd';

Line 1941: l_tabname_set(11) := 'ben_yr_perd';

1937: l_tabname_set(12) := 'ben_rptg_grp';
1938: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1939: --
1940: l_tabname_set(10) := 'ben_popl_yr_perd';
1941: l_tabname_set(11) := 'ben_yr_perd';
1942: l_tabname_set(12) := 'ben_rptg_grp';
1943: l_tabname_set(13) := 'ben_popl_rptg_grp';
1944: --
1945: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';