[Home] [Help]
4302: ,agf.age_calc_rl
4303: ,agf.mn_age_num
4304: ,agf.mx_age_num
4305: FROM ben_age_fctr agf
4306: ,ben_age_rt_f art
4307: ,ben_vrbl_rt_prfl_f vpf
4308: ,ben_acty_vrbl_rt_f avr
4309: ,ben_acty_base_rt_f abr
4310: WHERE abr.pgm_id = p_pgm_id
4371: ,agf.age_calc_rl
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
4595: ,agf.age_calc_rl
4596: ,agf.mn_age_num
4597: ,agf.mx_age_num
4598: FROM ben_age_fctr agf
4599: ,ben_age_rt_f art
4600: ,ben_vrbl_rt_prfl_f vpf
4601: ,ben_acty_vrbl_rt_f avr
4602: ,ben_acty_base_rt_f abr
4603: WHERE abr.pl_id = p_pl_id
4664: ,agf.age_calc_rl
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
4889: ,agf.age_calc_rl
4890: ,agf.mn_age_num
4891: ,agf.mx_age_num
4892: FROM ben_age_fctr agf
4893: ,ben_age_rt_f art
4894: ,ben_vrbl_rt_prfl_f vpf
4895: ,ben_acty_vrbl_rt_f avr
4896: ,ben_acty_base_rt_f abr
4897: WHERE ( abr.oipl_id = p_oipl_id
4965: ,agf.age_calc_rl
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
5200: ,agf.mx_age_num
5201: FROM ben_acty_base_rt_f abr
5202: ,ben_acty_vrbl_rt_f avr
5203: ,ben_vrbl_rt_prfl_f vpf
5204: ,ben_age_rt_f art
5205: ,ben_age_fctr agf
5206: WHERE abr.plip_id = p_plip_id
5207: AND p_effective_date BETWEEN abr.effective_start_date
5208: AND abr.effective_end_date
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
5281: AND abr.effective_end_date
5495: ,agf.mx_age_num
5496: FROM ben_acty_base_rt_f abr
5497: ,ben_acty_vrbl_rt_f avr
5498: ,ben_vrbl_rt_prfl_f vpf
5499: ,ben_age_rt_f art
5500: ,ben_age_fctr agf
5501: WHERE abr.ptip_id = p_ptip_id
5502: AND p_effective_date BETWEEN abr.effective_start_date
5503: AND abr.effective_end_date
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
5575: AND abr.effective_end_date
5788: ,agf.mx_age_num
5789: FROM ben_acty_base_rt_f abr
5790: ,ben_acty_vrbl_rt_f avr
5791: ,ben_vrbl_rt_prfl_f vpf
5792: ,ben_age_rt_f art
5793: ,ben_age_fctr agf
5794: WHERE abr.oiplip_id = p_oiplip_id
5795: AND p_effective_date BETWEEN abr.effective_start_date
5796: AND abr.effective_end_date
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
5868: AND abr.effective_end_date