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_IREC_PROCESS dependencies on BEN_ENRT_RT

Line 97: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe

93: IS
94: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
95: ecr.entr_val_at_enrt_flag, epe.pl_id, epe.pgm_id, epe.oipl_id,
96: ecr.acty_base_rt_id, ecr.ann_val
97: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe
98: WHERE epe.per_in_ler_id = cp_bckdt_per_in_ler_id
99: AND ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
100: AND ecr.entr_val_at_enrt_flag = 'Y'
101: AND ecr.spcl_rt_enrt_rt_id IS NULL

Line 106: FROM ben_enrt_rt ecr,

102: UNION
103: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
104: ecr.entr_val_at_enrt_flag, epe.pl_id, epe.pgm_id, epe.oipl_id,
105: ecr.acty_base_rt_id, ecr.ann_val
106: FROM ben_enrt_rt ecr,
107: ben_elig_per_elctbl_chc epe,
108: ben_enrt_bnft enb
109: WHERE ecr.enrt_bnft_id = enb.enrt_bnft_id
110: AND epe.per_in_ler_id = cp_bckdt_per_in_ler_id

Line 128: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe

124: IS
125: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
126: ecr.entr_val_at_enrt_flag, ecr.acty_base_rt_id, ecr.ann_val,
127: ecr.object_version_number, ecr.entr_ann_val_flag
128: FROM ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe
129: WHERE epe.per_in_ler_id = cp_irec_per_in_ler_id
130: AND ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
131: AND ecr.entr_val_at_enrt_flag = 'Y'
132: AND ecr.spcl_rt_enrt_rt_id IS NULL

Line 141: FROM ben_enrt_rt ecr,

137: UNION
138: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
139: ecr.entr_val_at_enrt_flag, ecr.acty_base_rt_id, ecr.ann_val,
140: ecr.object_version_number, ecr.entr_ann_val_flag
141: FROM ben_enrt_rt ecr,
142: ben_elig_per_elctbl_chc epe,
143: ben_enrt_bnft enb
144: WHERE ecr.enrt_bnft_id = enb.enrt_bnft_id
145: AND epe.per_in_ler_id = cp_irec_per_in_ler_id

Line 362: FROM ben_enrt_rt ecr

358: CURSOR c_rt (cp_elig_per_elctbl_chc_id NUMBER, cp_enrt_bnft_id NUMBER)
359: IS
360: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
361: ecr.entr_val_at_enrt_flag, ecr.acty_base_rt_id
362: FROM ben_enrt_rt ecr
363: WHERE ecr.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
364: AND ecr.business_group_id = p_business_group_id
365: -- AND ecr.entr_val_at_enrt_flag = 'Y'
366: AND ecr.spcl_rt_enrt_rt_id IS NULL

Line 370: FROM ben_enrt_rt ecr

366: AND ecr.spcl_rt_enrt_rt_id IS NULL
367: UNION
368: SELECT ecr.enrt_rt_id, ecr.dflt_val, ecr.val,
369: ecr.entr_val_at_enrt_flag, ecr.acty_base_rt_id
370: FROM ben_enrt_rt ecr
371: WHERE ecr.enrt_bnft_id = cp_enrt_bnft_id
372: AND ecr.business_group_id = p_business_group_id
373: -- AND ecr.entr_val_at_enrt_flag = 'Y'
374: AND ecr.spcl_rt_enrt_rt_id IS NULL;

Line 395: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,

391: l_prtt_rt_val_id10 NUMBER;
392: l_proc VARCHAR2 (72) := g_package || '.create_enrollment_for_irec';
393: --
394: TYPE g_rt_rec IS RECORD (
395: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
396: val ben_enrt_rt.val%TYPE,
397: dflt_val ben_enrt_rt.dflt_val%TYPE,
398: calc_val ben_enrt_rt.dflt_val%TYPE,
399: rt_strt_dt DATE,

Line 396: val ben_enrt_rt.val%TYPE,

392: l_proc VARCHAR2 (72) := g_package || '.create_enrollment_for_irec';
393: --
394: TYPE g_rt_rec IS RECORD (
395: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
396: val ben_enrt_rt.val%TYPE,
397: dflt_val ben_enrt_rt.dflt_val%TYPE,
398: calc_val ben_enrt_rt.dflt_val%TYPE,
399: rt_strt_dt DATE,
400: rt_end_dt DATE,

Line 397: dflt_val ben_enrt_rt.dflt_val%TYPE,

393: --
394: TYPE g_rt_rec IS RECORD (
395: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
396: val ben_enrt_rt.val%TYPE,
397: dflt_val ben_enrt_rt.dflt_val%TYPE,
398: calc_val ben_enrt_rt.dflt_val%TYPE,
399: rt_strt_dt DATE,
400: rt_end_dt DATE,
401: cmcd_rt_val NUMBER,

Line 398: calc_val ben_enrt_rt.dflt_val%TYPE,

394: TYPE g_rt_rec IS RECORD (
395: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
396: val ben_enrt_rt.val%TYPE,
397: dflt_val ben_enrt_rt.dflt_val%TYPE,
398: calc_val ben_enrt_rt.dflt_val%TYPE,
399: rt_strt_dt DATE,
400: rt_end_dt DATE,
401: cmcd_rt_val NUMBER,
402: ann_rt_val NUMBER

Line 409: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,

405: TYPE g_rt_table IS TABLE OF g_rt_rec
406: INDEX BY BINARY_INTEGER;
407: --
408: TYPE g_unres_rec IS RECORD (
409: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
410: val ben_enrt_rt.val%TYPE,
411: dflt_val ben_enrt_rt.dflt_val%TYPE,
412: calc_val ben_enrt_rt.dflt_val%TYPE,
413: rt_strt_dt DATE,

Line 410: val ben_enrt_rt.val%TYPE,

406: INDEX BY BINARY_INTEGER;
407: --
408: TYPE g_unres_rec IS RECORD (
409: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
410: val ben_enrt_rt.val%TYPE,
411: dflt_val ben_enrt_rt.dflt_val%TYPE,
412: calc_val ben_enrt_rt.dflt_val%TYPE,
413: rt_strt_dt DATE,
414: rt_end_dt DATE,

Line 411: dflt_val ben_enrt_rt.dflt_val%TYPE,

407: --
408: TYPE g_unres_rec IS RECORD (
409: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
410: val ben_enrt_rt.val%TYPE,
411: dflt_val ben_enrt_rt.dflt_val%TYPE,
412: calc_val ben_enrt_rt.dflt_val%TYPE,
413: rt_strt_dt DATE,
414: rt_end_dt DATE,
415: cmcd_rt_val NUMBER,

Line 412: calc_val ben_enrt_rt.dflt_val%TYPE,

408: TYPE g_unres_rec IS RECORD (
409: enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE,
410: val ben_enrt_rt.val%TYPE,
411: dflt_val ben_enrt_rt.dflt_val%TYPE,
412: calc_val ben_enrt_rt.dflt_val%TYPE,
413: rt_strt_dt DATE,
414: rt_end_dt DATE,
415: cmcd_rt_val NUMBER,
416: ann_rt_val NUMBER