APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_YR_PERD

Line 1028: -- ,ben_yr_perd yrp

1024: pgm.drvbl_fctr_apls_rts_flag,
1025: pgm.trk_inelig_per_flag
1026: FROM -- ben_popl_yr_perd cpy
1027: ben_pgm_f pgm
1028: -- ,ben_yr_perd yrp
1029: WHERE pgm.business_group_id = p_business_group_id
1030: AND pgm.pgm_id = NVL(p_pgm_id, pgm.pgm_id)
1031: AND pgm.pgm_stat_cd = 'A'
1032: AND (

Line 1044: from ben_yr_perd yrp,

1040: AND pgm.effective_end_date
1041: AND p_mode not in ('D','I')
1042: AND (p_mode = 'G' or
1043: exists (select null
1044: from ben_yr_perd yrp,
1045: ben_popl_yr_perd cpy
1046: where cpy.pgm_id = pgm.pgm_id
1047: AND cpy.yr_perd_id = yrp.yr_perd_id
1048: AND cpy.business_group_id = pgm.business_group_id

Line 1369: ,ben_yr_perd yrp

1365: pgm.drvbl_fctr_apls_rts_flag,
1366: pgm.trk_inelig_per_flag
1367: FROM ben_popl_yr_perd cpy
1368: ,ben_pgm_f pgm
1369: ,ben_yr_perd yrp
1370: WHERE pgm.business_group_id = p_business_group_id
1371: AND pgm.pgm_stat_cd = 'A'
1372: AND pgm.pgm_typ_cd LIKE 'COBRA%'
1373: AND p_effective_date BETWEEN pgm.effective_start_date

Line 1411: -- ben_yr_perd yrp,

1407: pln.drvbl_fctr_apls_rts_flag,
1408: pln.trk_inelig_per_flag
1409: FROM ben_pl_f pln,
1410: ben_pl_typ_f ptp
1411: -- ben_yr_perd yrp,
1412: -- ben_popl_yr_perd cpy
1413: WHERE pln.business_group_id = p_business_group_id
1414: AND p_effective_date BETWEEN pln.effective_start_date
1415: AND pln.effective_end_date

Line 1428: from ben_yr_perd yrp,

1424: /* Make sure that the plan is not in the plip table.
1425: or may not have been stated by the user. */
1426: AND (p_mode IN ('P','G','D') or -- ICM
1427: exists (select null
1428: from ben_yr_perd yrp,
1429: ben_popl_yr_perd cpy
1430: where cpy.pl_id = pln.pl_id
1431: AND cpy.yr_perd_id = yrp.yr_perd_id
1432: AND cpy.business_group_id = pln.business_group_id

Line 1572: -- ben_yr_perd yrp,

1568: pln.trk_inelig_per_flag
1569: FROM ben_pl_f pln,
1570: ben_pl_typ_f ptp,
1571: -- ben_popl_yr_perd cpy,
1572: -- ben_yr_perd yrp,
1573: ben_plip_f plp,
1574: ben_ptip_f ctp
1575: WHERE pln.business_group_id = p_business_group_id
1576: AND pln.pl_id = plp.pl_id

Line 1593: from ben_yr_perd yrp,

1589: AND plp.effective_end_date
1590:
1591: AND (p_mode = 'G' or
1592: exists (select null
1593: from ben_yr_perd yrp,
1594: ben_popl_yr_perd cpy
1595: where cpy.pl_id = pln.pl_id
1596: AND cpy.yr_perd_id = yrp.yr_perd_id
1597: AND cpy.business_group_id = pln.business_group_id

Line 1618: -- ,ben_yr_perd yrp

1614: cop.trk_inelig_per_flag
1615: FROM ben_oipl_f cop
1616: ,ben_opt_f opt
1617: -- ,ben_popl_yr_perd cpy
1618: -- ,ben_yr_perd yrp
1619: ,ben_pl_f pln
1620: WHERE cop.business_group_id = p_business_group_id
1621: AND p_effective_date BETWEEN cop.effective_start_date
1622: AND cop.effective_end_date

Line 1637: from ben_yr_perd yrp,

1633: AND opt.effective_end_date
1634:
1635: AND (p_mode in ('G','D') or
1636: exists (select null
1637: from ben_yr_perd yrp,
1638: ben_popl_yr_perd cpy
1639: where cpy.pl_id = cop.pl_id
1640: AND cpy.yr_perd_id = yrp.yr_perd_id
1641: AND cpy.business_group_id = cop.business_group_id

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

1914: l_tabname_set(8) := 'ben_prtn_elig_prfl_f';
1915: l_tabname_set(9) := 'ben_eligy_prfl_f';
1916: --
1917: l_tabname_set(10) := 'ben_popl_yr_perd';
1918: l_tabname_set(11) := 'ben_yr_perd';
1919: l_tabname_set(12) := 'ben_rptg_grp';
1920: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1921: --
1922: l_tabname_set(10) := 'ben_popl_yr_perd';

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

1919: l_tabname_set(12) := 'ben_rptg_grp';
1920: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1921: --
1922: l_tabname_set(10) := 'ben_popl_yr_perd';
1923: l_tabname_set(11) := 'ben_yr_perd';
1924: l_tabname_set(12) := 'ben_rptg_grp';
1925: l_tabname_set(13) := 'ben_popl_rptg_grp';
1926: --
1927: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';