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_REC_DET_PAYSUM_MODE dependencies on PAY_BALANCE_PKG

Line 130: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- bug8711855

126: g_taxable_etp number; /* Start 9226023 - Global varaibles to store Taxable and Tax Free portions of ETP */
127: g_tax_free_etp number; /* End 9226023 */
128:
129: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
130: p_lump_sum_E_ptd_tab pay_balance_pkg.t_balance_value_tab; -- bug8711855
131:
132: /* Changes for 9147438 start */
133:
134: -- Foreign Worker status check global variables

Line 165: g_fw_result_table pay_balance_pkg.t_detailed_bal_out_tab;

161: -- Defined_balance_IDs for Foregin Worker balances
162: p_fw_fbt_bal_type_tab pay_au_foreign_workers.tab_bal_type;
163: p_fw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
164: p_fw_alw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
165: g_fw_result_table pay_balance_pkg.t_detailed_bal_out_tab;
166: g_fw_input_alw_table pay_au_foreign_workers.tab_bal_type;
167: g_fw_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
168:
169: -- Global variables for comparison

Line 167: g_fw_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;

163: p_fw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
164: p_fw_alw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
165: g_fw_result_table pay_balance_pkg.t_detailed_bal_out_tab;
166: g_fw_input_alw_table pay_au_foreign_workers.tab_bal_type;
167: g_fw_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
168:
169: -- Global variables for comparison
170: g_net_balance number ;
171: g_fw_union_value number;

Line 186: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;

182:
183: p_fw_allowance_tab pay_au_payment_summary.t_allowance_balance%type;
184: g_balance_type_id pay_balance_types.balance_type_id%type;
185: p_fw_union_balance_type_tab pay_au_foreign_workers.tab_bal_type;
186: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
187:
188:
189: /* Changes for 9147438 end */
190: --------------------------------------------------------------------

Line 844: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

840: ,pay_assignment_actions rpac
841: ,pay_payroll_actions rppa
842: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
843: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
844: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id
845: + decode(rppa.payroll_id, 0, 0, 0),c_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)
846: AND rppa.action_type in ('R','Q','B','I')
847: AND rpac.tax_unit_id = c_legal_employer
848: AND rppa.payroll_action_id = rpac.payroll_action_id

Line 927: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

923: ,pay_assignment_actions rpac
924: ,pay_payroll_actions rppa
925: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
926: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
927: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id
928: + decode(rppa.payroll_id, 0, 0, 0),c_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)
929: AND rppa.action_type in ('R','Q','B','I')
930: AND rpac.tax_unit_id = c_legal_employer
931: AND rppa.payroll_action_id = rpac.payroll_action_id

Line 1014: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

1010: ,pay_assignment_actions rpac
1011: ,pay_payroll_actions rppa
1012: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
1013: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
1014: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id
1015: + decode(rppa.payroll_id, 0, 0, 0),c_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)
1016: AND rppa.action_type in ('R','Q','B','I')
1017: AND rpac.tax_unit_id = c_legal_employer
1018: AND rppa.payroll_action_id = rpac.payroll_action_id

Line 1775: pay_balance_pkg.get_value(p_assignment_action_id => l_assignment_action_id,

1771: g_context_table(1).tax_unit_id := g_tax_unit_id;
1772:
1773: if (l_assignment_action_id is NOT NULL)
1774: then
1775: pay_balance_pkg.get_value(p_assignment_action_id => l_assignment_action_id,
1776: p_defined_balance_lst=>g_balance_value_tab,
1777: p_context_lst =>g_context_table,
1778: p_output_table=>g_result_table);
1779:

Line 2227: l_fw_fbt_output_tab pay_balance_pkg.t_detailed_bal_out_tab;

2223: l_fbt_rate number;
2224: l_procedure varchar2(240);
2225:
2226: /* Changes for 9147438 start */
2227: l_fw_fbt_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
2228: l_fw_f_type varchar2(1);
2229: l_fw_j_type varchar2(1);
2230: f_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
2231: j_fw_date_tab pay_au_foreign_workers.tab_fw_dates;

Line 2250: l_bal_value := pay_balance_pkg.get_value(g_fbt_defined_balance_id

2246: close c_max_assignment_action_id;
2247:
2248: if (l_max_assignment_action_id is NOT null)
2249: then
2250: l_bal_value := pay_balance_pkg.get_value(g_fbt_defined_balance_id
2251: ,l_max_assignment_action_id
2252: ,g_tax_unit_id
2253: ,null,null,null,null,null);
2254:

Line 2972: ,pay_balance_pkg.get_value(pdb.defined_balance_id

2968:
2969: CURSOR c_allowance_balances IS
2970: SELECT pdb.defined_balance_id
2971: ,NVL(pbt.reporting_name,pbt.balance_name) balance_name
2972: ,pay_balance_pkg.get_value(pdb.defined_balance_id
2973: ,p_run_assignment_action_id
2974: ,g_tax_unit_id
2975: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL) balance_value
2976: FROM pay_balance_attributes pba