eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PGM_F

Line 1009: (pgm_id ben_pgm_f.pgm_id%type

1005: TYPE v2_set IS TABLE OF VARCHAR2(30)
1006: INDEX BY BINARY_INTEGER;
1007: --
1008: type pgm_rec is record
1009: (pgm_id ben_pgm_f.pgm_id%type
1010: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
1011: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
1012: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
1013: );

Line 1010: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type

1006: INDEX BY BINARY_INTEGER;
1007: --
1008: type pgm_rec is record
1009: (pgm_id ben_pgm_f.pgm_id%type
1010: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
1011: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
1012: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
1013: );
1014: --

Line 1011: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type

1007: --
1008: type pgm_rec is record
1009: (pgm_id ben_pgm_f.pgm_id%type
1010: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
1011: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
1012: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
1013: );
1014: --
1015: l_plninst_set ben_pln_cache.g_bgppln_cache;

Line 1012: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type

1008: type pgm_rec is record
1009: (pgm_id ben_pgm_f.pgm_id%type
1010: ,drvbl_fctr_prtn_elig_flag ben_pgm_f.drvbl_fctr_prtn_elig_flag%type
1011: ,drvbl_fctr_apls_rts_flag ben_pgm_f.drvbl_fctr_apls_rts_flag%type
1012: ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
1013: );
1014: --
1015: l_plninst_set ben_pln_cache.g_bgppln_cache;
1016: l_copinst_set ben_cop_cache.g_bgpcop_cache;

Line 1020: l_pgm_id ben_pgm_f.pgm_id%TYPE;

1016: l_copinst_set ben_cop_cache.g_bgpcop_cache;
1017: --
1018: l_oipl_id ben_oipl_f.oipl_id%TYPE;
1019: l_pl_id ben_pl_f.pl_id%TYPE;
1020: l_pgm_id ben_pgm_f.pgm_id%TYPE;
1021: l_pgm pgm_rec;
1022: l_pln ben_pln_cache.g_bgppln_rec;
1023: l_cop ben_cop_cache.g_bgpcop_rec;
1024: l_plip ben_plip_f%ROWTYPE;

Line 1042: ben_pgm_f pgm

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

Line 1383: ,ben_pgm_f pgm

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

Line 1709: FROM ben_pgm_f

1705: --
1706: CURSOR c_chgpgm(
1707: c_timestamp IN DATE) IS
1708: SELECT NULL
1709: FROM ben_pgm_f
1710: WHERE c_timestamp < last_update_date;
1711: --
1712: l_tabname_set v2_set;
1713: --

Line 1737: from ben_pgm_f

1733: --
1734: -- Added for # 3330283
1735: cursor c_unres_cache_only IS
1736: select distinct alws_unrstrctd_enrt_flag
1737: from ben_pgm_f
1738: where pgm_id in ( SELECT distinct bcocr.pgm_id
1739: FROM ben_comp_obj_cache_row bcocr
1740: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id )
1741: order by 1;

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

1919: -- with the database
1920: --
1921: -- - Check comp object level changes
1922: --
1923: l_tabname_set(0) := 'ben_pgm_f';
1924: l_tabname_set(1) := 'ben_ptip_f';
1925: l_tabname_set(2) := 'ben_plip_f';
1926: l_tabname_set(3) := 'ben_pl_f';
1927: l_tabname_set(4) := 'ben_opt_f';

Line 2920: from ben_pgm_f pgm

2916: l_oiplip_flag_bit_val BINARY_INTEGER := 0;
2917: --
2918: cursor c_pgm (cv_pgm_id number) is
2919: select pgm.drvbl_fctr_prtn_elig_flag, pgm.drvbl_fctr_apls_rts_flag, pgm.trk_inelig_per_flag
2920: from ben_pgm_f pgm
2921: where pgm.pgm_id = cv_pgm_id
2922: and pgm.pgm_stat_cd = 'A'
2923: and p_effective_date between pgm.effective_start_date and pgm.effective_end_date;
2924: --