APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CA_BALANCE_PKG

Line 1299: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1295: end; /* end for select of max assignment action id */
1296:
1297: if l_max_aaid <> -9999 then
1298: l_value := l_value +
1299: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1300: ('Gross Earnings',
1301: 'YTD' ,
1302: l_max_aaid,
1303: l_assignment_id ,

Line 1312: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1308: 'QC'
1309: ),0) ;
1310:
1311: ln_no_gross_earnings := ln_no_gross_earnings +
1312: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1313: ('RL2 No Gross Earnings',
1314: 'YTD' ,
1315: l_max_aaid,
1316: l_assignment_id ,

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

2368: hr_utility.trace('l_count is ' || to_char(l_count));
2369:
2370: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2371: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2372: result := result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2373: ( l_balance_type_tab(i),
2374: 'YTD' ,
2375: l_aaid,
2376: l_asgid ,

Line 3091: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3087: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
3088: hr_utility.trace('l_count is ' || to_char(l_count));
3089:
3090: ln_no_gross_earnings := ln_no_gross_earnings +
3091: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3092: ('RL2 No Gross Earnings',
3093: 'YTD' ,
3094: l_aaid,
3095: l_asgid,

Line 3132: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3128:
3129: if l_balance_type_tab(i) = 'Gross Earnings' then
3130:
3131: fed_result :=
3132: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3133: ('Taxable Benefits for Federal',
3134: 'YTD' ,
3135: l_aaid,
3136: l_asgid ,

Line 3220: l_fi_result := l_fi_result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3216: hr_utility.trace('l_count_fi is ' || to_char(l_count_fi));
3217: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3218: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3219: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3220: l_fi_result := l_fi_result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3221: ( l_fi_balance_type_tab(i),
3222: 'YTD' ,
3223: l_aaid,
3224: l_asgid ,

Line 3538: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3534: l_aaid);
3535: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3536:
3537: l_footnote_amount := l_footnote_amount +
3538: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3539: ( l_footnote_balance,
3540: 'YTD' ,
3541: l_aaid,
3542: l_asgid ,