APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_YR_PERD

Line 1026: FROM -- ben_popl_yr_perd cpy

1022: select pgm.pgm_id,
1023: pgm.drvbl_fctr_prtn_elig_flag,
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)

Line 1045: ben_popl_yr_perd cpy

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
1049: AND p_effective_date BETWEEN yrp.start_date AND yrp.end_date))

Line 1367: FROM ben_popl_yr_perd cpy

1363: select pgm.pgm_id,
1364: pgm.drvbl_fctr_prtn_elig_flag,
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'

Line 1412: -- ben_popl_yr_perd cpy

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
1416: /* Bug No 4402873 Added condition to retrieve plans with code as

Line 1429: ben_popl_yr_perd cpy

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
1433: AND p_effective_date BETWEEN yrp.start_date AND yrp.end_date))

Line 1571: -- ben_popl_yr_perd cpy,

1567: pln.drvbl_fctr_apls_rts_flag,
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

Line 1594: ben_popl_yr_perd cpy

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
1598: AND p_effective_date BETWEEN yrp.start_date AND yrp.end_date))

Line 1617: -- ,ben_popl_yr_perd cpy

1613: cop.drvbl_fctr_apls_rts_flag,
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

Line 1638: ben_popl_yr_perd cpy

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
1642: AND p_effective_date BETWEEN yrp.start_date AND yrp.end_date))

Line 1917: l_tabname_set(10) := 'ben_popl_yr_perd';

1913: l_tabname_set(7) := 'ben_prtn_elig_f';
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: --

Line 1922: 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';
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: --