APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PAY_BALANCE_PKG

Line 99: l_total_taxable := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)+

95: raise no_data_found;
96: end if;
97: CLOSE csr_get_def_bal_id;
98:
99: l_total_taxable := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)+
100: nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
101:
102: return(l_total_taxable);
103: end;

Line 100: nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

96: end if;
97: CLOSE csr_get_def_bal_id;
98:
99: l_total_taxable := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)+
100: nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
101:
102: return(l_total_taxable);
103: end;
104: -----------------------------------------------------------------------------------

Line 126: l_total_itax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)

122: raise no_data_found;
123: end if;
124: CLOSE csr_get_def_bal_id;
125:
126: l_total_itax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
127: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
128:
129: return(l_total_itax);
130: end;

Line 127: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

123: end if;
124: CLOSE csr_get_def_bal_id;
125:
126: l_total_itax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
127: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
128:
129: return(l_total_itax);
130: end;
131: -----------------------------------------------------------------------------------

Line 153: l_total_rtax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)

149: CLOSE csr_get_def_bal_id;
150: raise no_data_found;
151: end if;
152: CLOSE csr_get_def_bal_id;
153: l_total_rtax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
154: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
155: return(l_total_rtax);
156: end;
157: -----------------------------------------------------------------------------------

Line 154: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

150: raise no_data_found;
151: end if;
152: CLOSE csr_get_def_bal_id;
153: l_total_rtax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
154: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
155: return(l_total_rtax);
156: end;
157: -----------------------------------------------------------------------------------
158: -- Bug : 4568233

Line 179: l_total_stax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)

175: raise no_data_found;
176: end if;
177: CLOSE csr_get_def_bal_id;
178:
179: l_total_stax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
180: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
181: return(l_total_stax);
182: end;
183: -----------------------------------------------------------------------------------

Line 180: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);

176: end if;
177: CLOSE csr_get_def_bal_id;
178:
179: l_total_stax := nvl(pay_balance_pkg.get_value(l_def_balance_id1,p_assignment_id,p_effective_date),0)
180: +nvl(pay_balance_pkg.get_value(l_def_balance_id2,p_assignment_id,p_effective_date),0);
181: return(l_total_stax);
182: end;
183: -----------------------------------------------------------------------------------
184: -- Gets the YTD balance for Overseas Earnings

Line 201: l_ovs_bal := nvl(pay_balance_pkg.get_value(l_def_balance_id,p_assignment_id,p_effective_date),0);

197: raise no_data_found;
198: end if;
199: CLOSE csr_get_def_bal_id_ytd;
200:
201: l_ovs_bal := nvl(pay_balance_pkg.get_value(l_def_balance_id,p_assignment_id,p_effective_date),0);
202:
203: return(l_ovs_bal);
204: end;
205:

Line 1890: p_hi_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,

1886: --
1887: open csr_get_def_bal_id_ytd('HI_PREM_EE') ;
1888: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1889: if csr_get_def_bal_id_ytd%found then
1890: p_hi_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1891: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1892: end if ;
1893: close csr_get_def_bal_id_ytd ;
1894: --

Line 1899: p_ltci_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,

1895: -- Bug 7260606
1896: open csr_get_def_bal_id_ytd('LTCI_PREM_EE') ;
1897: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1898: if csr_get_def_bal_id_ytd%found then
1899: p_ltci_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1900: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1901: end if ;
1902: close csr_get_def_bal_id_ytd ;
1903: -- End of Bug 7260606

Line 1908: p_ei_prem := pay_balance_pkg.get_value(l_def_bal_id,

1904: --
1905: open csr_get_def_bal_id_ytd('EI_PREM') ;
1906: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1907: if csr_get_def_bal_id_ytd%found then
1908: p_ei_prem := pay_balance_pkg.get_value(l_def_bal_id,
1909: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1910: end if ;
1911: close csr_get_def_bal_id_ytd ;
1912: --

Line 1916: p_np_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,

1912: --
1913: open csr_get_def_bal_id_ytd('NP_PREM_EE') ;
1914: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1915: if csr_get_def_bal_id_ytd%found then
1916: p_np_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1917: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1918: end if ;
1919: close csr_get_def_bal_id_ytd ;
1920: --

Line 1925: p_pen_prem_bal := pay_balance_pkg.get_value(l_def_bal_id,

1921: -- Bug 6024342
1922: open csr_get_def_bal_id_ytd('Pension Premium') ;
1923: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1924: if csr_get_def_bal_id_ytd%found then
1925: p_pen_prem_bal := pay_balance_pkg.get_value(l_def_bal_id,
1926: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1927: end if ;
1928: close csr_get_def_bal_id_ytd ;
1929: --

Line 1934: p_post_office_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,

1930: -- Bug 9737699
1931: open csr_get_def_bal_id_ytd('Post Office Pension') ;
1932: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1933: if csr_get_def_bal_id_ytd%found then
1934: p_post_office_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,
1935: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1936: end if ;
1937: close csr_get_def_bal_id_ytd ;
1938: --

Line 1943: p_pvt_school_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,

1939: -- Bug 9737699
1940: open csr_get_def_bal_id_ytd('Private School Pension') ;
1941: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1942: if csr_get_def_bal_id_ytd%found then
1943: p_pvt_school_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,
1944: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1945: end if ;
1946: close csr_get_def_bal_id_ytd ;
1947: --

Line 1952: p_military_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,

1948: -- Bug 9737699
1949: open csr_get_def_bal_id_ytd('Military Pension Premium') ;
1950: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1951: if csr_get_def_bal_id_ytd%found then
1952: p_military_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,
1953: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1954: end if ;
1955: close csr_get_def_bal_id_ytd ;
1956: --