APPS.BEN_DERIVE_PART_AND_RATE_CACHE dependencies on BEN_AGE_FCTR

Line 3193: FROM ben_age_fctr agf

3189: ,agf.rndg_rl
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

Line 3378: FROM ben_age_fctr agf

3374: ,agf.rndg_rl
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

Line 3562: FROM ben_age_fctr agf

3558: ,agf.rndg_rl
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

Line 3746: FROM ben_age_fctr agf

3742: ,agf.rndg_rl
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

Line 3930: FROM ben_age_fctr agf

3926: ,agf.rndg_rl
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

Line 4109: FROM ben_age_fctr agf

4105: ,agf.rndg_rl
4106: ,agf.age_calc_rl
4107: ,agf.mn_age_num
4108: ,agf.mx_age_num
4109: FROM ben_age_fctr agf
4110: WHERE agf.age_fctr_id = p_age_fctr_id;
4111: --
4112: l_index PLS_INTEGER;
4113: l_not_hash_found BOOLEAN;

Line 4305: FROM ben_age_fctr agf

4301: ,agf.rndg_rl
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

Line 4374: FROM ben_age_fctr agf

4370: ,agf.rndg_rl
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

Line 4598: FROM ben_age_fctr agf

4594: ,agf.rndg_rl
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

Line 4667: FROM ben_age_fctr agf

4663: ,agf.rndg_rl
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

Line 4892: FROM ben_age_fctr agf

4888: ,agf.rndg_rl
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

Line 4968: FROM ben_age_fctr agf

4964: ,agf.rndg_rl
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

Line 5205: ,ben_age_fctr agf

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
5209: AND abr.acty_base_rt_id = avr.acty_base_rt_id

Line 5278: ,ben_age_fctr agf

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
5282: AND abr.acty_base_rt_id = avr.acty_base_rt_id

Line 5500: ,ben_age_fctr agf

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
5504: AND abr.acty_base_rt_id = avr.acty_base_rt_id

Line 5572: ,ben_age_fctr agf

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
5576: AND abr.acty_base_rt_id = avr.acty_base_rt_id

Line 5793: ,ben_age_fctr agf

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
5797: AND abr.acty_base_rt_id = avr.acty_base_rt_id

Line 5865: ,ben_age_fctr agf

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
5869: AND abr.acty_base_rt_id = avr.acty_base_rt_id