DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on PAY_BALANCE_PKG

Line 287: nvl(pay_balance_pkg.get_value(

283: BEGIN
284:
285: if p_defined_balance_id is not null then
286: ln_bal_value := fnd_number.number_to_canonical(
287: nvl(pay_balance_pkg.get_value(
288: p_defined_balance_id,
289: p_balcall_aaid),0));
290: end if;
291: return (ln_bal_value);

Line 1886: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

1882: fetch c_get_jurisdiction into l_jurisdiction_code;
1883: exit when c_get_jurisdiction%notfound;
1884:
1885:
1886: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1887:
1888: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction_code);
1889:
1890: hr_utility.trace('l_jurisdiction '|| to_char(l_jurisdiction_code));

Line 1888: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction_code);

1884:
1885:
1886: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1887:
1888: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction_code);
1889:
1890: hr_utility.trace('l_jurisdiction '|| to_char(l_jurisdiction_code));
1891:
1892: --Archiving this balance to get the value of PSD Withheld

Line 3011: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);

3007: loop
3008: fetch c_get_jurisdiction into l_jurisdiction;
3009: exit when c_get_jurisdiction%notfound;
3010:
3011: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
3012:
3013: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction);
3014:
3015: hr_utility.trace('l_jurisdiction '|| to_char(l_jurisdiction));

Line 3013: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction);

3009: exit when c_get_jurisdiction%notfound;
3010:
3011: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
3012:
3013: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction);
3014:
3015: hr_utility.trace('l_jurisdiction '|| to_char(l_jurisdiction));
3016:
3017: --Archiving this balance to get the value of PSD Withheld