eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_BALANCE_PKG

Line 131: *** correct assignment_action_id based on action_sequence to pay_balance_pkg.Also handled

127: *** 28-MAY-04 punmehta 115.112 Bug#3642409 - Removed Rownum from cursor process_assignments.
128: *** 03-JUN-04 abhkumar 115.113 Bug#3661230 - Modified the process assignment cursor to take all the employees for archiving purpose.
129: *** 21-JUN-04 srrajago 115.118 Bug#3701869 - Modified the cursor csr_get_bbr_aseq to fetch max action_sequence instead of
130: *** assignment_action_id. Introduced cursor csr_get_bbr_assignment_action to pass the
131: *** correct assignment_action_id based on action_sequence to pay_balance_pkg.Also handled
132: *** the parameter Last Year Termination value setting if it is not enabled.
133: *** 21-JUN-04 srrajago 115.119 Bug#3701869 - Modified cursors 'csr_get_bbr_aseq' and 'csr_get_bbr_asg_actions'. Handled the parameter
134: *** Last Year Termination value setting if it is not enabled in another place which was
135: *** missed in the previous fix.

Line 307: p_balance_value_tab pay_balance_pkg.t_balance_value_tab; -- 3172963

303: --
304: -------------------------------------------------------------------------------------------------------+
305: -- Define global variable to store defined_balance_id's and the corresponding balance values for BBR.
306: -------------------------------------------------------------------------------------------------------+
307: p_balance_value_tab pay_balance_pkg.t_balance_value_tab; -- 3172963
308: p_context_table pay_balance_pkg.t_context_tab; -- 2610141
309: p_result_table pay_balance_pkg.t_detailed_bal_out_tab; -- 2610141
310: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- 8711855
311:

Line 308: p_context_table pay_balance_pkg.t_context_tab; -- 2610141

304: -------------------------------------------------------------------------------------------------------+
305: -- Define global variable to store defined_balance_id's and the corresponding balance values for BBR.
306: -------------------------------------------------------------------------------------------------------+
307: p_balance_value_tab pay_balance_pkg.t_balance_value_tab; -- 3172963
308: p_context_table pay_balance_pkg.t_context_tab; -- 2610141
309: p_result_table pay_balance_pkg.t_detailed_bal_out_tab; -- 2610141
310: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- 8711855
311:
312: ---------------------------------------------------------------------------------------------------------------------------+

Line 309: p_result_table pay_balance_pkg.t_detailed_bal_out_tab; -- 2610141

305: -- Define global variable to store defined_balance_id's and the corresponding balance values for BBR.
306: -------------------------------------------------------------------------------------------------------+
307: p_balance_value_tab pay_balance_pkg.t_balance_value_tab; -- 3172963
308: p_context_table pay_balance_pkg.t_context_tab; -- 2610141
309: p_result_table pay_balance_pkg.t_detailed_bal_out_tab; -- 2610141
310: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- 8711855
311:
312: ---------------------------------------------------------------------------------------------------------------------------+
313: --Bug 6192381

Line 310: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- 8711855

306: -------------------------------------------------------------------------------------------------------+
307: p_balance_value_tab pay_balance_pkg.t_balance_value_tab; -- 3172963
308: p_context_table pay_balance_pkg.t_context_tab; -- 2610141
309: p_result_table pay_balance_pkg.t_detailed_bal_out_tab; -- 2610141
310: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- 8711855
311:
312: ---------------------------------------------------------------------------------------------------------------------------+
313: --Bug 6192381
314: --For ETP Payment Balances define global variable to store defined_balance_id's and the corresponding balance values for BBR.

Line 317: p_etp_balance_value_tab pay_balance_pkg.t_balance_value_tab;

313: --Bug 6192381
314: --For ETP Payment Balances define global variable to store defined_balance_id's and the corresponding balance values for BBR.
315: ---------------------------------------------------------------------------------------------------------------------------+
316:
317: p_etp_balance_value_tab pay_balance_pkg.t_balance_value_tab;
318: p_etp_context_table pay_balance_pkg.t_context_tab;
319: p_etp_result_table pay_balance_pkg.t_detailed_bal_out_tab;
320:
321: /* Bug 6470581 - PL/SQL table to hold Archive Items when submitted for Amended payment summary */

Line 318: p_etp_context_table pay_balance_pkg.t_context_tab;

314: --For ETP Payment Balances define global variable to store defined_balance_id's and the corresponding balance values for BBR.
315: ---------------------------------------------------------------------------------------------------------------------------+
316:
317: p_etp_balance_value_tab pay_balance_pkg.t_balance_value_tab;
318: p_etp_context_table pay_balance_pkg.t_context_tab;
319: p_etp_result_table pay_balance_pkg.t_detailed_bal_out_tab;
320:
321: /* Bug 6470581 - PL/SQL table to hold Archive Items when submitted for Amended payment summary */
322: p_all_dbi_tab pay_au_payment_summary_amend.archive_db_tab ;

Line 319: p_etp_result_table pay_balance_pkg.t_detailed_bal_out_tab;

315: ---------------------------------------------------------------------------------------------------------------------------+
316:
317: p_etp_balance_value_tab pay_balance_pkg.t_balance_value_tab;
318: p_etp_context_table pay_balance_pkg.t_context_tab;
319: p_etp_result_table pay_balance_pkg.t_detailed_bal_out_tab;
320:
321: /* Bug 6470581 - PL/SQL table to hold Archive Items when submitted for Amended payment summary */
322: p_all_dbi_tab pay_au_payment_summary_amend.archive_db_tab ;
323:

Line 351: p_etp_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;

347:
348: /* end bug 9147430 */
349:
350: /* bug 14703826 - balance plsql tables for new ETP balances */
351: p_etp_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
352: p_etp_non_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
353: p_etp_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
354: p_etp_non_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
355:

Line 352: p_etp_non_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;

348: /* end bug 9147430 */
349:
350: /* bug 14703826 - balance plsql tables for new ETP balances */
351: p_etp_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
352: p_etp_non_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
353: p_etp_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
354: p_etp_non_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
355:
356: --------------------------------------------------------------------+

Line 353: p_etp_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;

349:
350: /* bug 14703826 - balance plsql tables for new ETP balances */
351: p_etp_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
352: p_etp_non_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
353: p_etp_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
354: p_etp_non_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
355:
356: --------------------------------------------------------------------+
357: -- This procedure returns a sql string to select a range

Line 354: p_etp_non_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;

350: /* bug 14703826 - balance plsql tables for new ETP balances */
351: p_etp_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
352: p_etp_non_excl_bal_value_tab pay_balance_pkg.t_balance_value_tab;
353: p_etp_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
354: p_etp_non_excl_result_table pay_balance_pkg.t_detailed_bal_out_tab;
355:
356: --------------------------------------------------------------------+
357: -- This procedure returns a sql string to select a range
358: -- of assignments eligible for archival.

Line 1226: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

1222: ,pay_assignment_actions rpac
1223: ,pay_payroll_actions rppa
1224: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1225: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1226: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id
1227: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141
1228: and rppa.action_type in ('R','Q','B','I')
1229: and rpac.tax_unit_id = v_reg_emp
1230: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1321: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

1317: ,pay_assignment_actions rpac
1318: ,pay_payroll_actions rppa
1319: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1320: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1321: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id
1322: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141
1323: and rppa.action_type in ('R','Q','B','I')
1324: and rpac.tax_unit_id = v_reg_emp
1325: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1429: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

1425: ,pay_assignment_actions rpac
1426: ,pay_payroll_actions rppa
1427: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1428: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1429: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id
1430: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141
1431: and rppa.action_type in ('R','Q','B','I')
1432: and rpac.tax_unit_id = v_reg_emp
1433: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1568: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

1564: ,pay_assignment_actions rpac
1565: ,pay_payroll_actions rppa
1566: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end
1567: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1568: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id
1569: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold)
1570: and rppa.action_type in ('R','Q','B','I')
1571: and rpac.tax_unit_id = v_reg_emp
1572: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1665: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

1661: ,pay_assignment_actions rpac
1662: ,pay_payroll_actions rppa
1663: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1664: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1665: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id
1666: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141
1667: and rppa.action_type in ('R','Q','B','I')
1668: and rpac.tax_unit_id = v_reg_emp
1669: and rppa.payroll_action_id = rpac.payroll_action_id

Line 2223: select pay_balance_pkg.get_value(pdb.defined_balance_id,

2219: cursor c_archive_fbt_info(c_balance_name pay_balance_types.balance_name%type,
2220: c_year_end DATE,
2221: c_assignment_id pay_assignment_actions.assignment_id%type)
2222: is
2223: select pay_balance_pkg.get_value(pdb.defined_balance_id,
2224: p_max_assignment_action_id,
2225: p_registered_employer,
2226: null,null,null,null) --2610141
2227: from pay_balance_types pbt,

Line 2268: l_fw_fbt_output_tab pay_balance_pkg.t_detailed_bal_out_tab;

2264:
2265: e_bad_global exception ;
2266:
2267: /*bug9147430*/
2268: l_fw_fbt_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
2269: l_fw_reporting_amt Number := 0;
2270: l_fw_f_type varchar2(1);
2271: l_fw_j_type varchar2(1);
2272: f_fw_date_tab pay_au_foreign_workers.tab_fw_dates;

Line 3142: l_leave_balance_value_tab pay_balance_pkg.t_balance_value_tab;

3138: l_tax NUMBER;
3139:
3140: l_proc_name VARCHAR2(100);
3141:
3142: l_leave_balance_value_tab pay_balance_pkg.t_balance_value_tab;
3143: l_leave_context_table pay_balance_pkg.t_context_tab;
3144: l_result_table pay_balance_pkg.t_detailed_bal_out_tab;
3145:
3146: BEGIN

Line 3143: l_leave_context_table pay_balance_pkg.t_context_tab;

3139:
3140: l_proc_name VARCHAR2(100);
3141:
3142: l_leave_balance_value_tab pay_balance_pkg.t_balance_value_tab;
3143: l_leave_context_table pay_balance_pkg.t_context_tab;
3144: l_result_table pay_balance_pkg.t_detailed_bal_out_tab;
3145:
3146: BEGIN
3147:

Line 3144: l_result_table pay_balance_pkg.t_detailed_bal_out_tab;

3140: l_proc_name VARCHAR2(100);
3141:
3142: l_leave_balance_value_tab pay_balance_pkg.t_balance_value_tab;
3143: l_leave_context_table pay_balance_pkg.t_context_tab;
3144: l_result_table pay_balance_pkg.t_detailed_bal_out_tab;
3145:
3146: BEGIN
3147:
3148: g_debug := hr_utility.debug_enabled;

Line 3175: pay_balance_pkg.get_value

3171: l_result_table.DELETE;
3172:
3173: IF csr_rec.assignment_action_id IS NOT NULL
3174: THEN
3175: pay_balance_pkg.get_value
3176: (p_assignment_action_id => csr_rec.assignment_action_id
3177: ,p_defined_balance_lst => l_leave_balance_value_tab
3178: ,p_context_lst => l_leave_context_table
3179: ,p_output_table => l_result_table

Line 3343: l_fw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;

3339: l_fw_tot_sub_balance number :=0;
3340: l_fw_tot_net_balance number := 0;
3341: l_payg_fw_type varchar2(10) := 'P';
3342: l_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
3343: l_fw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3344: l_fw_alw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3345: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3346: l_fw_start_date date;
3347: l_fw_end_date date;

Line 3344: l_fw_alw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;

3340: l_fw_tot_net_balance number := 0;
3341: l_payg_fw_type varchar2(10) := 'P';
3342: l_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
3343: l_fw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3344: l_fw_alw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3345: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3346: l_fw_start_date date;
3347: l_fw_end_date date;
3348: l_fw_date varchar2(20);

Line 3345: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;

3341: l_payg_fw_type varchar2(10) := 'P';
3342: l_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
3343: l_fw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3344: l_fw_alw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3345: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3346: l_fw_start_date date;
3347: l_fw_end_date date;
3348: l_fw_date varchar2(20);
3349: x number;

Line 4205: ,pay_balance_pkg.get_value(pdb.defined_balance_id

4201:
4202: CURSOR get_allowance_balances IS
4203: SELECT pdb.defined_balance_id
4204: ,NVL(pbt.reporting_name,pbt.balance_name) balance_name
4205: ,pay_balance_pkg.get_value(pdb.defined_balance_id
4206: ,p_max_assignment_action_id
4207: ,p_registered_employer
4208: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL) balance_value
4209: FROM pay_balance_attributes pba

Line 4517: and (pay_balance_pkg.get_value(pkg_lump_sum_c_def_bal_id, pac.assignment_action_id,p_registered_employer,null,null,null,null)) > 0 --2610141

4513: and pac.action_status = 'C'
4514: and ppa.action_status = 'C'
4515: and ppa.payroll_id = paf.payroll_id /* Added for bug 5371102 for performance*/
4516: and ppa.date_earned between paf.effective_start_date and paf.effective_end_date /* Added for bug 5371102 for performance*/
4517: and (pay_balance_pkg.get_value(pkg_lump_sum_c_def_bal_id, pac.assignment_action_id,p_registered_employer,null,null,null,null)) > 0 --2610141
4518: and ppa.effective_date between c_year_start
4519: and c_year_end ;
4520:
4521: r_etp_ba_or_bi etp_BA_or_BI%rowtype;

Line 4644: , pay_balance_pkg.get_value(pdb.defined_balance_id, p_max_assignment_action_id, p_registered_employer,null,null,null,null) balance_value

4640: -- Bug#5591993 Removed join for table pay_balance_type to avoid MJC
4641: -- and moved the code to cursor c_union_balance(initliazation code).
4642: cursor csr_unions_2006 (c_balance_type pay_balance_types.balance_type_id%type) is
4643: select distinct nvl(pbt.reporting_name, pbt.balance_name) balance_name
4644: , pay_balance_pkg.get_value(pdb.defined_balance_id, p_max_assignment_action_id, p_registered_employer,null,null,null,null) balance_value
4645: , pdb.defined_balance_id def_id
4646: , pbt.balance_type_id bal_type_id
4647: from pay_element_types_f pet
4648: , per_all_assignments_f paa

Line 5574: /*Bug 6192381 Introduced call to pay_balance_pkg.get_value to use BBR for ETP Payment Balances

5570: ,l_post30jun1983_ratio -- number out
5571: ,l_etp_service_date -- date out
5572: ,l_le_etp_service_date); -- date out /* Bug 4177679 */
5573:
5574: /*Bug 6192381 Introduced call to pay_balance_pkg.get_value to use BBR for ETP Payment Balances
5575: Removed cursor get_etp_payment_value and its call*/
5576:
5577: p_etp_result_table.delete;
5578:

Line 5581: pay_balance_pkg.get_value

5577: p_etp_result_table.delete;
5578:
5579: p_etp_context_table(1).tax_unit_id := p_registered_employer;
5580: --
5581: pay_balance_pkg.get_value
5582: (p_assignment_action_id => p_max_assignment_action_id
5583: ,p_defined_balance_lst => p_etp_balance_value_tab
5584: ,p_context_lst => p_etp_context_table
5585: ,p_output_table => p_etp_result_table

Line 6055: and (pay_balance_pkg.get_value(c_lsC_payments_def_bal_id, pac.assignment_action_id,p_registered_employer,null,null,null,null)) <> 0

6051: and pac.action_status = 'C'
6052: and ppa.action_status = 'C'
6053: and ppa.payroll_id = paf.payroll_id
6054: and ppa.date_earned between paf.effective_start_date and paf.effective_end_date
6055: and (pay_balance_pkg.get_value(c_lsC_payments_def_bal_id, pac.assignment_action_id,p_registered_employer,null,null,null,null)) <> 0
6056: and ppa.effective_date between p_year_start and p_year_end
6057: order by pac.assignment_action_id;
6058:
6059: TYPE prepost_rec IS RECORD (payment_date varchar2(20),

Line 6150: pay_balance_pkg.get_value

6146: IF rec_deduction.assignment_action_id <> l_ex_assignment_action_id THEN /* for multiple ETP on Termination entries in the same run */
6147:
6148: p_etp_excl_result_table.delete;
6149:
6150: pay_balance_pkg.get_value
6151: (p_assignment_action_id => rec_deduction.assignment_action_id
6152: ,p_defined_balance_lst => p_etp_excl_bal_value_tab
6153: ,p_context_lst => p_etp_context_table
6154: ,p_output_table => p_etp_excl_result_table

Line 6232: pay_balance_pkg.get_value

6228: IF rec_deduction.assignment_action_id <> l_ne_assignment_action_id THEN /* for multiple ETP on Termination entries in the same run */
6229:
6230: p_etp_non_excl_result_table.delete;
6231:
6232: pay_balance_pkg.get_value
6233: (p_assignment_action_id => rec_deduction.assignment_action_id
6234: ,p_defined_balance_lst => p_etp_non_excl_bal_value_tab
6235: ,p_context_lst => p_etp_context_table
6236: ,p_output_table => p_etp_non_excl_result_table

Line 6302: pay_balance_pkg.get_value

6298: end if;
6299:
6300: p_etp_excl_result_table.delete;
6301:
6302: pay_balance_pkg.get_value
6303: (p_assignment_action_id => r_BA_BI.assignment_action_id
6304: ,p_defined_balance_lst => p_etp_excl_bal_value_tab
6305: ,p_context_lst => p_etp_context_table
6306: ,p_output_table => p_etp_excl_result_table

Line 6381: pay_balance_pkg.get_value

6377: hr_utility.set_location('r_BA_BI.payroll_action_id '||r_BA_BI.payroll_action_id,4);
6378: end if;
6379: p_etp_non_excl_result_table.delete;
6380:
6381: pay_balance_pkg.get_value
6382: (p_assignment_action_id => r_BA_BI.assignment_action_id
6383: ,p_defined_balance_lst => p_etp_non_excl_bal_value_tab
6384: ,p_context_lst => p_etp_context_table
6385: ,p_output_table => p_etp_non_excl_result_table

Line 8598: if (pay_balance_pkg.get_value(pkg_lump_sum_c_def_bal_id, l_max_assignment_action_id, l_registered_employer,null,null,null,null) > 0) then --2610141

8594: , l_max_assignment_action_id -- 3019374
8595: , l_final_process_date; -- 3263659
8596: --
8597: if etp_code%found then -- 3019374
8598: if (pay_balance_pkg.get_value(pkg_lump_sum_c_def_bal_id, l_max_assignment_action_id, l_registered_employer,null,null,null,null) > 0) then --2610141
8599: lump_sum_c_found := true;
8600: if g_debug then
8601: hr_utility.set_location('Lump Sum C Payment found.' ,9 );
8602: end if;

Line 8827: pay_balance_pkg.get_value

8823: -- Changes made for bug 2610141 Start here
8824: --
8825: p_context_table(1).tax_unit_id := l_registered_employer;
8826: --
8827: pay_balance_pkg.get_value
8828: (p_assignment_action_id => l_bbr_assignment_action_id
8829: ,p_defined_balance_lst => p_balance_value_tab
8830: ,p_context_lst => p_context_table
8831: ,p_output_table => p_result_table

Line 9507: ,p_lump_sum_E_ptd_tab in pay_balance_pkg.t_balance_value_tab

9503: (p_registered_employer in NUMBER
9504: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
9505: ,p_year_start in DATE
9506: ,p_year_end in DATE
9507: ,p_lump_sum_E_ptd_tab in pay_balance_pkg.t_balance_value_tab
9508: ,p_lump_sum_E_ytd in number
9509: ,p_adj_lump_sum_E_ptd out nocopy number
9510: ,p_adj_lump_sum_pre_tax out nocopy NUMBER) return number IS
9511:

Line 9553: p_result_lsE_ptd_table pay_balance_pkg.t_detailed_bal_out_tab;

9549: v_lump_sum_E_ptd number;
9550: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
9551: v_adj_lump_sum_E_ptd number := 0;
9552: v_adj_lump_sum_pre_tax NUMBER := 0; /* Bug 9190980 */
9553: p_result_lsE_ptd_table pay_balance_pkg.t_detailed_bal_out_tab;
9554:
9555: begin
9556: g_debug := hr_utility.debug_enabled;
9557:

Line 9577: pay_balance_pkg.get_value

9573: v_lump_sum_E_ptd := 0;
9574:
9575: p_context_table(1).tax_unit_id := p_registered_employer;
9576: --
9577: pay_balance_pkg.get_value
9578: (p_assignment_action_id => l_assignment_action_id
9579: ,p_defined_balance_lst => p_lump_sum_E_ptd_tab
9580: ,p_context_lst => p_context_table
9581: ,p_output_table => p_result_lsE_ptd_table