APPS.BEN_CWB_DYN_CALC_PKG dependencies on BEN_CWB_PERSON_RATES

Line 161: ,ben_cwb_person_rates pl

157: ,null new_grd_mid_point
158: ,null new_grd_comparatio
159: ,null new_grd_quartile
160: from ben_cwb_person_info inf
161: ,ben_cwb_person_rates pl
162: ,ben_cwb_pl_dsgn dsgn
163: ,ben_transaction perf
164: ,ben_transaction asg
165: ,ben_cwb_person_rates opt1

Line 165: ,ben_cwb_person_rates opt1

161: ,ben_cwb_person_rates pl
162: ,ben_cwb_pl_dsgn dsgn
163: ,ben_transaction perf
164: ,ben_transaction asg
165: ,ben_cwb_person_rates opt1
166: ,ben_cwb_person_rates opt2
167: ,ben_cwb_person_rates opt3
168: ,ben_cwb_person_rates opt4
169: where inf.group_per_in_ler_id = v_group_per_in_ler_id

Line 166: ,ben_cwb_person_rates opt2

162: ,ben_cwb_pl_dsgn dsgn
163: ,ben_transaction perf
164: ,ben_transaction asg
165: ,ben_cwb_person_rates opt1
166: ,ben_cwb_person_rates opt2
167: ,ben_cwb_person_rates opt3
168: ,ben_cwb_person_rates opt4
169: where inf.group_per_in_ler_id = v_group_per_in_ler_id
170: and inf.group_per_in_ler_id = pl.group_per_in_ler_id

Line 167: ,ben_cwb_person_rates opt3

163: ,ben_transaction perf
164: ,ben_transaction asg
165: ,ben_cwb_person_rates opt1
166: ,ben_cwb_person_rates opt2
167: ,ben_cwb_person_rates opt3
168: ,ben_cwb_person_rates opt4
169: where inf.group_per_in_ler_id = v_group_per_in_ler_id
170: and inf.group_per_in_ler_id = pl.group_per_in_ler_id
171: and pl.oipl_id = -1

Line 168: ,ben_cwb_person_rates opt4

164: ,ben_transaction asg
165: ,ben_cwb_person_rates opt1
166: ,ben_cwb_person_rates opt2
167: ,ben_cwb_person_rates opt3
168: ,ben_cwb_person_rates opt4
169: where inf.group_per_in_ler_id = v_group_per_in_ler_id
170: and inf.group_per_in_ler_id = pl.group_per_in_ler_id
171: and pl.oipl_id = -1
172: and pl.elig_flag = 'Y'

Line 1728: ben_cwb_person_rates_api.update_person_rate

1724: ,cpi_attribute30 = g_allocation_row.cpi_attribute30
1725: where group_per_in_ler_id = g_allocation_row.group_per_in_ler_id;
1726: end if;
1727: if g_upd_pl_rate then
1728: ben_cwb_person_rates_api.update_person_rate
1729: (p_validate => false
1730: ,p_group_per_in_ler_id => g_allocation_row.group_per_in_ler_id
1731: ,p_pl_id => g_allocation_row.pl_id
1732: ,p_oipl_id => -1

Line 1748: ben_cwb_person_rates_api.update_person_rate

1744: ,p_object_version_number => g_allocation_row.ovn_pl);
1745: l_save_summary := true;
1746: end if;
1747: if g_upd_opt1_rate then
1748: ben_cwb_person_rates_api.update_person_rate
1749: (p_validate => false
1750: ,p_group_per_in_ler_id => g_allocation_row.group_per_in_ler_id
1751: ,p_pl_id => g_allocation_row.pl_id
1752: ,p_oipl_id => g_allocation_row.oipl_id_opt1

Line 1768: ben_cwb_person_rates_api.update_person_rate

1764: ,p_object_version_number => g_allocation_row.ovn_opt1);
1765: l_save_summary := true;
1766: end if;
1767: if g_upd_opt2_rate then
1768: ben_cwb_person_rates_api.update_person_rate
1769: (p_validate => false
1770: ,p_group_per_in_ler_id => g_allocation_row.group_per_in_ler_id
1771: ,p_pl_id => g_allocation_row.pl_id
1772: ,p_oipl_id => g_allocation_row.oipl_id_opt2

Line 1788: ben_cwb_person_rates_api.update_person_rate

1784: ,p_object_version_number => g_allocation_row.ovn_opt2);
1785: l_save_summary := true;
1786: end if;
1787: if g_upd_opt3_rate then
1788: ben_cwb_person_rates_api.update_person_rate
1789: (p_validate => false
1790: ,p_group_per_in_ler_id => g_allocation_row.group_per_in_ler_id
1791: ,p_pl_id => g_allocation_row.pl_id
1792: ,p_oipl_id => g_allocation_row.oipl_id_opt3

Line 1808: ben_cwb_person_rates_api.update_person_rate

1804: ,p_object_version_number => g_allocation_row.ovn_opt3);
1805: l_save_summary := true;
1806: end if;
1807: if g_upd_opt4_rate then
1808: ben_cwb_person_rates_api.update_person_rate
1809: (p_validate => false
1810: ,p_group_per_in_ler_id => g_allocation_row.group_per_in_ler_id
1811: ,p_pl_id => g_allocation_row.pl_id
1812: ,p_oipl_id => g_allocation_row.oipl_id_opt4