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_POPULATE_RBV dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 12: Type t_epe_tab is table of ben_elig_per_elctbl_chc%rowtype index by binary_integer;

8: Type t_crp_tab is table of ben_cbr_per_in_ler%rowtype index by binary_integer;
9: Type t_cqb_tab is table of ben_cbr_quald_bnf%rowtype index by binary_integer;
10: Type t_pep_tab is table of ben_elig_per_f%rowtype index by binary_integer;
11: Type t_epo_tab is table of ben_elig_per_opt_f%rowtype index by binary_integer;
12: Type t_epe_tab is table of ben_elig_per_elctbl_chc%rowtype index by binary_integer;
13: Type t_pel_tab is table of ben_pil_elctbl_chc_popl%rowtype index by binary_integer;
14: Type t_ecc_tab is table of ben_elctbl_chc_ctfn%rowtype index by binary_integer;
15: Type t_egd_tab is table of ben_elig_dpnt%rowtype index by binary_integer;
16: Type t_pdp_tab is table of ben_elig_cvrd_dpnt_f%rowtype index by binary_integer;

Line 849: insert into ben_elig_per_elctbl_chc_rbv

845: --
846: for elenum in p_epe_set.first ..p_epe_set.last
847: loop
848: --
849: insert into ben_elig_per_elctbl_chc_rbv
850: ( elig_per_elctbl_chc_id,
851: -- enrt_typ_cycl_cd,
852: enrt_cvg_strt_dt_cd,
853: -- enrt_perd_end_dt,

Line 3055: from ben_elig_per_elctbl_chc epe,

3051: ,c_lu_dt date
3052: )
3053: is
3054: select epe.*
3055: from ben_elig_per_elctbl_chc epe,
3056: ben_per_in_ler pil
3057: where pil.person_id = c_per_id
3058: and epe.per_in_ler_id = pil.per_in_ler_id
3059: and epe.last_update_date

Line 3085: ben_elig_per_elctbl_chc epe,

3081: )
3082: is
3083: select ecc.*
3084: from ben_elctbl_chc_ctfn ecc,
3085: ben_elig_per_elctbl_chc epe,
3086: ben_per_in_ler pil
3087: where pil.person_id = c_per_id
3088: and epe.per_in_ler_id = pil.per_in_ler_id
3089: and epe.ELIG_PER_ELCTBL_CHC_ID = ecc.ELIG_PER_ELCTBL_CHC_ID

Line 3095: ben_elig_per_elctbl_chc epe,

3091: union
3092: select ecc.*
3093: from ben_elctbl_chc_ctfn ecc,
3094: ben_enrt_bnft enb,
3095: ben_elig_per_elctbl_chc epe,
3096: ben_per_in_ler pil
3097: where pil.person_id = c_per_id
3098: and epe.per_in_ler_id = pil.per_in_ler_id
3099: and epe.ELIG_PER_ELCTBL_CHC_ID = enb.ELIG_PER_ELCTBL_CHC_ID

Line 3112: ben_elig_per_elctbl_chc epe,

3108: )
3109: is
3110: select ecc.*
3111: from ben_elctbl_chc_ctfn ecc,
3112: ben_elig_per_elctbl_chc epe,
3113: ben_per_in_ler pil
3114: where pil.person_id = c_per_id
3115: and epe.per_in_ler_id = pil.per_in_ler_id
3116: and epe.ELIG_PER_ELCTBL_CHC_ID = ecc.ELIG_PER_ELCTBL_CHC_ID

Line 3131: ben_elig_per_elctbl_chc epe,

3127: is
3128: select ecc.*
3129: from ben_elctbl_chc_ctfn ecc,
3130: ben_enrt_bnft enb,
3131: ben_elig_per_elctbl_chc epe,
3132: ben_per_in_ler pil
3133: where pil.person_id = c_per_id
3134: and epe.per_in_ler_id = pil.per_in_ler_id
3135: and epe.ELIG_PER_ELCTBL_CHC_ID = enb.ELIG_PER_ELCTBL_CHC_ID

Line 3191: ben_elig_per_elctbl_chc epe,

3187: )
3188: is
3189: select enb.*
3190: from ben_enrt_bnft enb,
3191: ben_elig_per_elctbl_chc epe,
3192: ben_per_in_ler pil
3193: where pil.person_id = c_per_id
3194: and epe.per_in_ler_id = pil.per_in_ler_id
3195: and epe.ELIG_PER_ELCTBL_CHC_ID = enb.ELIG_PER_ELCTBL_CHC_ID

Line 3208: ben_elig_per_elctbl_chc epe,

3204: )
3205: is
3206: select epr.*
3207: from ben_enrt_prem epr,
3208: ben_elig_per_elctbl_chc epe,
3209: ben_per_in_ler pil
3210: where pil.person_id = c_per_id
3211: and epe.per_in_ler_id = pil.per_in_ler_id
3212: and epe.ELIG_PER_ELCTBL_CHC_ID = epr.ELIG_PER_ELCTBL_CHC_ID

Line 3219: ben_elig_per_elctbl_chc epe,

3215: union
3216: select epr.*
3217: from ben_enrt_prem epr,
3218: ben_enrt_bnft enb,
3219: ben_elig_per_elctbl_chc epe,
3220: ben_per_in_ler pil
3221: where pil.person_id = c_per_id
3222: and epe.per_in_ler_id = pil.per_in_ler_id
3223: and epe.ELIG_PER_ELCTBL_CHC_ID = enb.ELIG_PER_ELCTBL_CHC_ID

Line 3237: ben_elig_per_elctbl_chc epe,

3233: )
3234: is
3235: select epr.*
3236: from ben_enrt_prem epr,
3237: ben_elig_per_elctbl_chc epe,
3238: ben_per_in_ler pil
3239: where pil.person_id = c_per_id
3240: and epe.per_in_ler_id = pil.per_in_ler_id
3241: and epe.ELIG_PER_ELCTBL_CHC_ID = epr.ELIG_PER_ELCTBL_CHC_ID

Line 3254: ben_elig_per_elctbl_chc epe,

3250: is
3251: select epr.*
3252: from ben_enrt_prem epr,
3253: ben_enrt_bnft enb,
3254: ben_elig_per_elctbl_chc epe,
3255: ben_per_in_ler pil
3256: where pil.person_id = c_per_id
3257: and epe.per_in_ler_id = pil.per_in_ler_id
3258: and epe.ELIG_PER_ELCTBL_CHC_ID = enb.ELIG_PER_ELCTBL_CHC_ID

Line 3272: ben_elig_per_elctbl_chc epe,

3268: )
3269: is
3270: select ecr.*
3271: from ben_enrt_rt ecr,
3272: ben_elig_per_elctbl_chc epe,
3273: ben_per_in_ler pil
3274: where pil.person_id = c_per_id
3275: and epe.per_in_ler_id = pil.per_in_ler_id
3276: and epe.ELIG_PER_ELCTBL_CHC_ID = ecr.ELIG_PER_ELCTBL_CHC_ID

Line 3283: ben_elig_per_elctbl_chc epe,

3279: union
3280: select ecr.*
3281: from ben_enrt_rt ecr,
3282: ben_enrt_bnft enb,
3283: ben_elig_per_elctbl_chc epe,
3284: ben_per_in_ler pil
3285: where pil.person_id = c_per_id
3286: and epe.per_in_ler_id = pil.per_in_ler_id
3287: and epe.ELIG_PER_ELCTBL_CHC_ID = enb.ELIG_PER_ELCTBL_CHC_ID

Line 3301: ben_elig_per_elctbl_chc epe,

3297: )
3298: is
3299: select ecr.*
3300: from ben_enrt_rt ecr,
3301: ben_elig_per_elctbl_chc epe,
3302: ben_per_in_ler pil
3303: where pil.person_id = c_per_id
3304: and epe.per_in_ler_id = pil.per_in_ler_id
3305: and ecr.enrt_bnft_id is null

Line 3319: ben_elig_per_elctbl_chc epe,

3315: is
3316: select ecr.*
3317: from ben_enrt_rt ecr,
3318: ben_enrt_bnft enb,
3319: ben_elig_per_elctbl_chc epe,
3320: ben_per_in_ler pil
3321: where pil.person_id = c_per_id
3322: and epe.per_in_ler_id = pil.per_in_ler_id
3323: and epe.ELIG_PER_ELCTBL_CHC_ID = enb.ELIG_PER_ELCTBL_CHC_ID

Line 3388: from ben_elig_per_elctbl_chc epe,

3384: ,c_lu_dt date
3385: )
3386: is
3387: select cwbmh.*
3388: from ben_elig_per_elctbl_chc epe,
3389: ben_per_in_ler pil,
3390: ben_cwb_mgr_hrchy cwbmh
3391: where pil.person_id = c_per_id
3392: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3617: l_table_name := 'BEN_ELIG_PER_ELCTBL_CHC_RBV';

3613: );
3614: --
3615: -- Electability
3616: --
3617: l_table_name := 'BEN_ELIG_PER_ELCTBL_CHC_RBV';
3618: l_elenum := 0;
3619: --
3620: for row in c_eperbv
3621: (c_per_id => l_person_id