APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_CA_BALANCE_PKG

Line 1246: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1242: end;
1243:
1244: if l_max_aaid <> -9999 then
1245: l_value := l_value +
1246: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1247: ('Gross Earnings',
1248: 'YTD' ,
1249: l_max_aaid,
1250: l_assignment_id ,

Line 1259: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1255: 'QC'
1256: ),0) ;
1257:
1258: ln_no_gross_earnings := ln_no_gross_earnings +
1259: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1260: ('RL1 No Gross Earnings',
1261: 'YTD' ,
1262: l_max_aaid,
1263: l_assignment_id ,

Line 1272: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1268: 'QC'
1269: ),0);
1270:
1271: ln_nontaxable_earnings := ln_nontaxable_earnings +
1272: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1273: ('RL1 Non Taxable Earnings',
1274: 'YTD' ,
1275: l_max_aaid,
1276: l_assignment_id ,

Line 2848: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2844: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
2845: hr_utility.trace('l_count is ' || to_char(l_count));
2846:
2847: ln_no_gross_earnings := ln_no_gross_earnings +
2848: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2849: ('RL1 No Gross Earnings',
2850: 'YTD' ,
2851: l_aaid,
2852: l_asgid,

Line 2897: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2893:
2894: if l_balance_type_tab(i) = 'Gross Earnings' then
2895:
2896: fed_result :=
2897: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2898: ('Taxable Benefits for Federal',
2899: 'YTD' ,
2900: l_aaid,
2901: l_asgid ,

Line 2910: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2906: 'QC'
2907: ),0);
2908:
2909: non_taxable_earnings :=
2910: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2911: ('RL1 Non Taxable Earnings',
2912: 'YTD' ,
2913: l_aaid,
2914: l_asgid ,

Line 2932: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2928: hr_utility.trace('Non Taxable Earnings = ' || non_taxable_earnings);
2929: end if;
2930:
2931: ln_balance_value :=
2932: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2933: ( l_balance_type_tab(i),
2934: 'YTD' ,
2935: l_aaid,
2936: l_asgid ,

Line 3180: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3176: l_ft_aaid);
3177: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3178:
3179: l_footnote_amount := l_footnote_amount +
3180: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3181: ( l_footnote_balance,
3182: 'YTD' ,
3183: l_ft_aaid,
3184: l_asgid ,

Line 3383: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3379: fetch c_get_max_asgactid into l_aaid1;
3380: close c_get_max_asgactid;
3381:
3382: result := result +
3383: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3384: ('CPP EE Withheld',
3385: 'YTD' ,
3386: l_aaid1,
3387: l_asgid,

Line 3395: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3391: l_business_group_id,
3392: NULL),0);
3393:
3394: lv_cpp_pensionable_earnings := lv_cpp_pensionable_earnings +
3395: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3396: ('CPP EE Taxable',
3397: 'YTD' ,
3398: l_aaid1,
3399: l_asgid,

Line 3407: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3403: l_business_group_id,
3404: NULL),0);
3405:
3406: lv_taxable_benefit_with_no_rem := lv_taxable_benefit_with_no_rem +
3407: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3408: ('Taxable Benefit without Remuneration',
3409: 'YTD' ,
3410: l_aaid1,
3411: l_asgid ,