APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_YR_PERD

Line 1041: FROM -- ben_popl_yr_perd cpy

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

Line 1060: ben_popl_yr_perd cpy

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

Line 1382: FROM ben_popl_yr_perd cpy

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

Line 1427: -- ben_popl_yr_perd cpy

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

Line 1444: ben_popl_yr_perd cpy

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

Line 1586: -- ben_popl_yr_perd cpy,

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

Line 1609: ben_popl_yr_perd cpy

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

Line 1632: -- ,ben_popl_yr_perd cpy

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

Line 1653: ben_popl_yr_perd cpy

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

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

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

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