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_EFC_ADJUSTMENTS dependencies on BEN_ELIG_PER_OPT_F

Line 2062: (elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type

2058: --
2059: TYPE cur_type IS REF CURSOR;
2060: --
2061: type g_efc_row is record
2062: (elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type
2063: ,effective_start_date ben_elig_per_opt_f.effective_start_date%type
2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type
2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type

Line 2063: ,effective_start_date ben_elig_per_opt_f.effective_start_date%type

2059: TYPE cur_type IS REF CURSOR;
2060: --
2061: type g_efc_row is record
2062: (elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type
2063: ,effective_start_date ben_elig_per_opt_f.effective_start_date%type
2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type
2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type

Line 2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type

2060: --
2061: type g_efc_row is record
2062: (elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type
2063: ,effective_start_date ben_elig_per_opt_f.effective_start_date%type
2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type
2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type

Line 2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type

2061: type g_efc_row is record
2062: (elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type
2063: ,effective_start_date ben_elig_per_opt_f.effective_start_date%type
2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type
2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type

Line 2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type

2062: (elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%type
2063: ,effective_start_date ben_elig_per_opt_f.effective_start_date%type
2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type
2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type

Line 2070: ,opt_id ben_elig_per_opt_f.opt_id%type

2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type
2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type

Line 2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type

2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type
2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type
2075: ,object_version_number ben_elig_per_opt_f.object_version_number%type

Line 2073: ,creation_date ben_elig_per_opt_f.creation_date%type

2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type
2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type
2075: ,object_version_number ben_elig_per_opt_f.object_version_number%type
2076: ,per_in_ler_id ben_elig_per_opt_f.per_in_ler_id%type
2077: );

Line 2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type

2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type
2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type
2075: ,object_version_number ben_elig_per_opt_f.object_version_number%type
2076: ,per_in_ler_id ben_elig_per_opt_f.per_in_ler_id%type
2077: );
2078: --

Line 2075: ,object_version_number ben_elig_per_opt_f.object_version_number%type

2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type
2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type
2075: ,object_version_number ben_elig_per_opt_f.object_version_number%type
2076: ,per_in_ler_id ben_elig_per_opt_f.per_in_ler_id%type
2077: );
2078: --
2079: c_efc_rows cur_type;

Line 2076: ,per_in_ler_id ben_elig_per_opt_f.per_in_ler_id%type

2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type
2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type
2075: ,object_version_number ben_elig_per_opt_f.object_version_number%type
2076: ,per_in_ler_id ben_elig_per_opt_f.per_in_ler_id%type
2077: );
2078: --
2079: c_efc_rows cur_type;
2080: --

Line 2196: FROM ben_elig_per_opt_f epo

2192: )
2193: IS
2194: select epo.elig_per_opt_id,
2195: count(*)
2196: FROM ben_elig_per_opt_f epo
2197: where epo.per_in_ler_id = c_per_in_ler_id
2198: and epo.elig_per_opt_id = c_elig_per_opt_id
2199: group by epo.elig_per_opt_id
2200: having count(*) > 1;

Line 2242: l_from_str := ' FROM ben_elig_per_opt_f epo, '

2238: l_efc_batch := TRUE;
2239: --
2240: end if;
2241: --
2242: l_from_str := ' FROM ben_elig_per_opt_f epo, '
2243: ||' ben_elig_per_f pep, '
2244: ||' ben_per_in_ler pil, '
2245: ||' per_all_people_f per ';
2246: --

Line 2270: l_from_str := l_from_str||', ben_elig_per_opt_f_efc efc ';

2266: -- Build in batch specific restrictions
2267: --
2268: if l_efc_batch then
2269: --
2270: l_from_str := l_from_str||', ben_elig_per_opt_f_efc efc ';
2271: l_where_str := l_where_str||' and efc.elig_per_opt_id = epo.elig_per_opt_id '
2272: ||' and efc.effective_start_date = epo.effective_start_date '
2273: ||' and efc.effective_end_date = epo.effective_end_date '
2274: ||' and efc.efc_action_id = :action_id '

Line 2643: update ben_elig_per_opt_f epo

2639: if l_efc_batch
2640: and l_faterr_code is null
2641: then
2642: --
2643: update ben_elig_per_opt_f epo
2644: set epo.comp_ref_amt = l_comp_rec.comp_ref_amt,
2645: epo.rt_comp_ref_amt = l_comp_rec.rt_comp_ref_amt
2646: where epo.elig_per_opt_id = l_efc_row.elig_per_opt_id
2647: and epo.effective_start_date = l_efc_row.effective_start_date

Line 2724: (p_table_name => 'ben_elig_per_opt_f'

2720: --
2721: -- Check that all rows have been converted or excluded
2722: --
2723: ben_efc_functions.conv_check
2724: (p_table_name => 'ben_elig_per_opt_f'
2725: ,p_efctable_name => 'ben_elig_per_opt_f_efc'
2726: ,p_tabwhere_clause => ' (comp_ref_amt is not null '
2727: ||' or rt_comp_ref_amt is not null) '
2728: --

Line 2725: ,p_efctable_name => 'ben_elig_per_opt_f_efc'

2721: -- Check that all rows have been converted or excluded
2722: --
2723: ben_efc_functions.conv_check
2724: (p_table_name => 'ben_elig_per_opt_f'
2725: ,p_efctable_name => 'ben_elig_per_opt_f_efc'
2726: ,p_tabwhere_clause => ' (comp_ref_amt is not null '
2727: ||' or rt_comp_ref_amt is not null) '
2728: --
2729: ,p_bgp_id => p_business_group_id