APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_CA_BALANCE_PKG

Line 1434: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1430: end;
1431:
1432: if l_max_aaid <> -9999 then
1433: l_value := l_value +
1434: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1435: ('Gross Earnings',
1436: 'YTD' ,
1437: l_max_aaid,
1438: l_assignment_id ,

Line 1447: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1443: 'QC'
1444: ),0) ;
1445:
1446: ln_no_gross_earnings := ln_no_gross_earnings +
1447: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1448: ('RL1 No Gross Earnings',
1449: 'YTD' ,
1450: l_max_aaid,
1451: l_assignment_id ,

Line 1460: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1456: 'QC'
1457: ),0);
1458:
1459: ln_nontaxable_earnings := ln_nontaxable_earnings +
1460: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1461: ('RL1 Non Taxable Earnings',
1462: 'YTD' ,
1463: l_max_aaid,
1464: l_assignment_id ,

Line 2732: result := result+nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2728: where target1.organization_id = l_tax_unit_id;
2729:
2730: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2731: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2732: result := result+nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2733: ( l_balance_type_tab(i),
2734: 'YTD' ,
2735: l_aaid,
2736: l_asgid ,

Line 3663: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3659: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
3660: hr_utility.trace('l_count is ' || to_char(l_count));
3661:
3662: ln_no_gross_earnings := ln_no_gross_earnings +
3663: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3664: ('RL1 No Gross Earnings',
3665: 'YTD' ,
3666: l_aaid,
3667: l_asgid,

Line 3712: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3708:
3709: if l_balance_type_tab(i) = 'Gross Earnings' then
3710:
3711: fed_result :=
3712: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3713: ('Taxable Benefits for Federal',
3714: 'YTD' ,
3715: l_aaid,
3716: l_asgid ,

Line 3725: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3721: 'QC'
3722: ),0);
3723:
3724: non_taxable_earnings :=
3725: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3726: ('RL1 Non Taxable Earnings',
3727: 'YTD' ,
3728: l_aaid,
3729: l_asgid ,

Line 3747: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3743: hr_utility.trace('Non Taxable Earnings = ' || non_taxable_earnings);
3744: end if;
3745:
3746: ln_balance_value :=
3747: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3748: ( l_balance_type_tab(i),
3749: 'YTD' ,
3750: l_aaid,
3751: l_asgid ,

Line 3998: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3994: l_ft_aaid);
3995: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3996:
3997: l_footnote_amount := l_footnote_amount +
3998: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3999: ( l_footnote_balance,
4000: 'YTD' ,
4001: l_ft_aaid,
4002: l_asgid ,

Line 4198: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

4194: fetch c_get_max_asgactid into l_aaid1;
4195: close c_get_max_asgactid;
4196:
4197: result := result +
4198: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
4199: ('CPP EE Withheld',
4200: 'YTD' ,
4201: l_aaid1,
4202: l_asgid,

Line 4210: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

4206: l_business_group_id,
4207: NULL),0);
4208:
4209: lv_cpp_pensionable_earnings := lv_cpp_pensionable_earnings +
4210: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
4211: ('CPP EE Taxable',
4212: 'YTD' ,
4213: l_aaid1,
4214: l_asgid,

Line 4222: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

4218: l_business_group_id,
4219: NULL),0);
4220:
4221: lv_taxable_benefit_with_no_rem := lv_taxable_benefit_with_no_rem +
4222: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
4223: ('Taxable Benefit without Remuneration',
4224: 'YTD' ,
4225: l_aaid1,
4226: l_asgid ,

Line 4235: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

4231: 'QC'),0);
4232:
4233: /*Bug 15914635 sbachu*/
4234: lv_tax_ben_no_rem_all_prov := lv_tax_ben_no_rem_all_prov +
4235: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
4236: ('Taxable Benefit without Remuneration',
4237: 'YTD' ,
4238: l_aaid1,
4239: l_asgid ,