APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PGM_F

Line 994: (pgm_id ben_pgm_f.pgm_id%type

990: TYPE v2_set IS TABLE OF VARCHAR2(30)
991: INDEX BY BINARY_INTEGER;
992: --
993: type pgm_rec is record
994: (pgm_id ben_pgm_f.pgm_id%type
995: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
996: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
997: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
998: );

Line 995: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type

991: INDEX BY BINARY_INTEGER;
992: --
993: type pgm_rec is record
994: (pgm_id ben_pgm_f.pgm_id%type
995: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
996: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
997: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
998: );
999: --

Line 996: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type

992: --
993: type pgm_rec is record
994: (pgm_id ben_pgm_f.pgm_id%type
995: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
996: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
997: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
998: );
999: --
1000: l_plninst_set ben_pln_cache.g_bgppln_cache;

Line 997: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type

993: type pgm_rec is record
994: (pgm_id ben_pgm_f.pgm_id%type
995: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
996: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
997: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
998: );
999: --
1000: l_plninst_set ben_pln_cache.g_bgppln_cache;
1001: l_copinst_set ben_cop_cache.g_bgpcop_cache;

Line 1005: l_pgm_id ben_pgm_f.pgm_id%TYPE;

1001: l_copinst_set ben_cop_cache.g_bgpcop_cache;
1002: --
1003: l_oipl_id ben_oipl_f.oipl_id%TYPE;
1004: l_pl_id ben_pl_f.pl_id%TYPE;
1005: l_pgm_id ben_pgm_f.pgm_id%TYPE;
1006: l_pgm pgm_rec;
1007: l_pln ben_pln_cache.g_bgppln_rec;
1008: l_cop ben_cop_cache.g_bgpcop_rec;
1009: l_plip ben_plip_f%ROWTYPE;

Line 1027: ben_pgm_f pgm

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)
1031: AND pgm.pgm_stat_cd = 'A'

Line 1368: ,ben_pgm_f pgm

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'
1372: AND pgm.pgm_typ_cd LIKE 'COBRA%'

Line 1692: FROM ben_pgm_f

1688: --
1689: CURSOR c_chgpgm(
1690: c_timestamp IN DATE) IS
1691: SELECT NULL
1692: FROM ben_pgm_f
1693: WHERE c_timestamp < last_update_date;
1694: --
1695: l_tabname_set v2_set;
1696: --

Line 1720: from ben_pgm_f

1716: --
1717: -- Added for # 3330283
1718: cursor c_unres_cache_only IS
1719: select distinct alws_unrstrctd_enrt_flag
1720: from ben_pgm_f
1721: where pgm_id in ( SELECT distinct bcocr.pgm_id
1722: FROM ben_comp_obj_cache_row bcocr
1723: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id )
1724: order by 1;

Line 1905: l_tabname_set(0) := 'ben_pgm_f';

1901: -- with the database
1902: --
1903: -- - Check comp object level changes
1904: --
1905: l_tabname_set(0) := 'ben_pgm_f';
1906: l_tabname_set(1) := 'ben_ptip_f';
1907: l_tabname_set(2) := 'ben_plip_f';
1908: l_tabname_set(3) := 'ben_pl_f';
1909: l_tabname_set(4) := 'ben_opt_f';

Line 2900: from ben_pgm_f pgm

2896: l_oiplip_flag_bit_val BINARY_INTEGER := 0;
2897: --
2898: cursor c_pgm (cv_pgm_id number) is
2899: select pgm.drvbl_fctr_prtn_elig_flag, pgm.drvbl_fctr_apls_rts_flag, pgm.trk_inelig_per_flag
2900: from ben_pgm_f pgm
2901: where pgm.pgm_id = cv_pgm_id
2902: and pgm.pgm_stat_cd = 'A'
2903: and p_effective_date between pgm.effective_start_date and pgm.effective_end_date;
2904: --