APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CA_BALANCE_PKG

Line 1138: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1134: end; /* end for select of max assignment action id */
1135:
1136: if l_max_aaid <> -9999 then
1137: l_value := l_value +
1138: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1139: ('Gross Earnings',
1140: 'YTD' ,
1141: l_max_aaid,
1142: l_assignment_id ,

Line 1151: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1147: 'QC'
1148: ),0) ;
1149:
1150: ln_no_gross_earnings := ln_no_gross_earnings +
1151: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1152: ('RL2 No Gross Earnings',
1153: 'YTD' ,
1154: l_max_aaid,
1155: l_assignment_id ,

Line 2376: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2372: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
2373: hr_utility.trace('l_count is ' || to_char(l_count));
2374:
2375: ln_no_gross_earnings := ln_no_gross_earnings +
2376: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2377: ('RL2 No Gross Earnings',
2378: 'YTD' ,
2379: l_aaid,
2380: l_asgid,

Line 2417: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2413:
2414: if l_balance_type_tab(i) = 'Gross Earnings' then
2415:
2416: fed_result :=
2417: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2418: ('Taxable Benefits for Federal',
2419: 'YTD' ,
2420: l_aaid,
2421: l_asgid ,

Line 2766: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2762: l_aaid);
2763: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
2764:
2765: l_footnote_amount := l_footnote_amount +
2766: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2767: ( l_footnote_balance,
2768: 'YTD' ,
2769: l_aaid,
2770: l_asgid ,