APPS.BEN_DERIVE_PART_AND_RATE_CACHE dependencies on BEN_ELIG_AGE_PRTE_F

Line 3194: ,ben_elig_age_prte_f eap

3190: ,agf.age_calc_rl
3191: ,agf.mn_age_num
3192: ,agf.mx_age_num
3193: FROM ben_age_fctr agf
3194: ,ben_elig_age_prte_f eap
3195: ,ben_eligy_prfl_f elp
3196: ,ben_prtn_elig_prfl_f cep
3197: ,ben_prtn_elig_f epa
3198: WHERE epa.pgm_id = p_pgm_id

Line 3379: ,ben_elig_age_prte_f eap

3375: ,agf.age_calc_rl
3376: ,agf.mn_age_num
3377: ,agf.mx_age_num
3378: FROM ben_age_fctr agf
3379: ,ben_elig_age_prte_f eap
3380: ,ben_eligy_prfl_f elp
3381: ,ben_prtn_elig_prfl_f cep
3382: ,ben_prtn_elig_f epa
3383: WHERE epa.pl_id = p_pl_id

Line 3563: ,ben_elig_age_prte_f eap

3559: ,agf.age_calc_rl
3560: ,agf.mn_age_num
3561: ,agf.mx_age_num
3562: FROM ben_age_fctr agf
3563: ,ben_elig_age_prte_f eap
3564: ,ben_eligy_prfl_f elp
3565: ,ben_prtn_elig_prfl_f cep
3566: ,ben_prtn_elig_f epa
3567: WHERE epa.oipl_id = p_oipl_id

Line 3747: ,ben_elig_age_prte_f eap

3743: ,agf.age_calc_rl
3744: ,agf.mn_age_num
3745: ,agf.mx_age_num
3746: FROM ben_age_fctr agf
3747: ,ben_elig_age_prte_f eap
3748: ,ben_eligy_prfl_f elp
3749: ,ben_prtn_elig_prfl_f cep
3750: ,ben_prtn_elig_f epa
3751: WHERE epa.plip_id = p_plip_id

Line 3931: ,ben_elig_age_prte_f eap

3927: ,agf.age_calc_rl
3928: ,agf.mn_age_num
3929: ,agf.mx_age_num
3930: FROM ben_age_fctr agf
3931: ,ben_elig_age_prte_f eap
3932: ,ben_eligy_prfl_f elp
3933: ,ben_prtn_elig_prfl_f cep
3934: ,ben_prtn_elig_f epa
3935: WHERE epa.ptip_id = p_ptip_id

Line 4376: ,ben_elig_age_prte_f eap

4372: ,agf.mn_age_num
4373: ,agf.mx_age_num
4374: FROM ben_age_fctr agf
4375: --,ben_age_rt_f art
4376: ,ben_elig_age_prte_f eap
4377: ,ben_eligy_prfl_f elp
4378: ,ben_vrbl_rt_elig_prfl_f vep
4379: ,ben_vrbl_rt_prfl_f vpf
4380: ,ben_acty_vrbl_rt_f avr

Line 4669: ,ben_elig_age_prte_f eap

4665: ,agf.mn_age_num
4666: ,agf.mx_age_num
4667: FROM ben_age_fctr agf
4668: --,ben_age_rt_f art
4669: ,ben_elig_age_prte_f eap
4670: ,ben_eligy_prfl_f elp
4671: ,ben_vrbl_rt_elig_prfl_f vep
4672: ,ben_vrbl_rt_prfl_f vpf
4673: ,ben_acty_vrbl_rt_f avr

Line 4970: ,ben_elig_age_prte_f eap

4966: ,agf.mn_age_num
4967: ,agf.mx_age_num
4968: FROM ben_age_fctr agf
4969: --,ben_age_rt_f art
4970: ,ben_elig_age_prte_f eap
4971: ,ben_eligy_prfl_f elp
4972: ,ben_vrbl_rt_elig_prfl_f vep
4973: ,ben_vrbl_rt_prfl_f vpf
4974: ,ben_acty_vrbl_rt_f avr

Line 5276: ,ben_elig_age_prte_f eap

5272: ,ben_acty_vrbl_rt_f avr
5273: ,ben_eligy_prfl_f elp
5274: ,ben_vrbl_rt_elig_prfl_f vep
5275: ,ben_vrbl_rt_prfl_f vpf
5276: ,ben_elig_age_prte_f eap
5277: --,ben_age_rt_f art
5278: ,ben_age_fctr agf
5279: WHERE abr.plip_id = p_plip_id
5280: AND p_effective_date BETWEEN abr.effective_start_date

Line 5570: ,ben_elig_age_prte_f eap

5566: ,ben_acty_vrbl_rt_f avr
5567: ,ben_eligy_prfl_f elp
5568: ,ben_vrbl_rt_elig_prfl_f vep
5569: ,ben_vrbl_rt_prfl_f vpf
5570: ,ben_elig_age_prte_f eap
5571: --,ben_age_rt_f art
5572: ,ben_age_fctr agf
5573: WHERE abr.ptip_id = p_ptip_id
5574: AND p_effective_date BETWEEN abr.effective_start_date

Line 5863: ,ben_elig_age_prte_f eap

5859: ,ben_acty_vrbl_rt_f avr
5860: ,ben_eligy_prfl_f elp
5861: ,ben_vrbl_rt_elig_prfl_f vep
5862: ,ben_vrbl_rt_prfl_f vpf
5863: ,ben_elig_age_prte_f eap
5864: --,ben_age_rt_f art
5865: ,ben_age_fctr agf
5866: WHERE abr.oiplip_id = p_oiplip_id
5867: AND p_effective_date BETWEEN abr.effective_start_date