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 487: and pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

483: ,pay_assignment_actions rpac
484: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
485: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */
486: and rppa.effective_date between c_fbt_year_start and c_fbt_year_end
487: and pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id
488: + decode(rppa.payroll_id, 0, 0, 0),c_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)) /* Bug 5708255 */
489: )
490: and rppa.action_type in ('R','Q','B','I')
491: and rpac.tax_unit_id = c_legal_employer

Line 561: and pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

557: ,pay_assignment_actions rpac
558: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
559: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */
560: and rppa.effective_date between c_fbt_year_start and c_fbt_year_end
561: and pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id
562: + decode(rppa.payroll_id, 0, 0, 0),c_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)) /* Bug 5708255 */
563: )
564: and rppa.action_type in ('R','Q','B','I')
565: and rpac.tax_unit_id = c_legal_employer

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

636: ,pay_assignment_actions rpac
637: WHERE (rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
638: or ( pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
639: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
640: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id
641: + decode(rppa.payroll_id, 0, 0, 0),c_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)) /* Bug 5708255 */
642: )
643: AND rppa.action_type in ('R','Q','B','I')
644: AND rpac.tax_unit_id = c_legal_employer

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

1261: g_context_table(1).tax_unit_id := g_tax_unit_id;
1262:
1263: if (l_assignment_action_id is NOT NULL)
1264: then
1265: pay_balance_pkg.get_value(p_assignment_action_id => l_assignment_action_id,
1266: p_defined_balance_lst=>g_balance_value_tab,
1267: p_context_lst =>g_context_table,
1268: p_output_table=>g_result_table);
1269:

Line 1457: l_bal_value := pay_balance_pkg.get_value(g_fbt_defined_balance_id

1453: close c_max_assignment_action_id;
1454:
1455: if (l_max_assignment_action_id is NOT null)
1456: then
1457: l_bal_value := pay_balance_pkg.get_value(g_fbt_defined_balance_id
1458: ,l_max_assignment_action_id
1459: ,g_tax_unit_id
1460: ,null,null,null,null,null);
1461:

Line 1849: select sum(pay_balance_pkg.get_value(pdb.defined_balance_id,

1845: is
1846: CURSOR c_single_lumpsum_E_payment(c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
1847: c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
1848: IS
1849: select sum(pay_balance_pkg.get_value(pdb.defined_balance_id,
1850: c_assignment_action_id,
1851: c_tax_unit_id,
1852: null,null,null,null)) --2610141
1853: FROM pay_balance_types pbt,

Line 1963: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4177630 */

1959: and pbd.dimension_name = '_ASG_LE_YTD'
1960: and pbd.legislation_code ='AU';
1961:
1962:
1963: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4177630 */
1964: allow_context_table pay_balance_pkg.t_context_tab; /* 4177630 */
1965: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4177630 */
1966:
1967: tab_allownace_balance pay_au_payment_summary.t_allowance_balance%TYPE;

Line 1964: allow_context_table pay_balance_pkg.t_context_tab; /* 4177630 */

1960: and pbd.legislation_code ='AU';
1961:
1962:
1963: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4177630 */
1964: allow_context_table pay_balance_pkg.t_context_tab; /* 4177630 */
1965: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4177630 */
1966:
1967: tab_allownace_balance pay_au_payment_summary.t_allowance_balance%TYPE;
1968:

Line 1965: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4177630 */

1961:
1962:
1963: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4177630 */
1964: allow_context_table pay_balance_pkg.t_context_tab; /* 4177630 */
1965: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4177630 */
1966:
1967: tab_allownace_balance pay_au_payment_summary.t_allowance_balance%TYPE;
1968:
1969: l_YTD_allowance number;

Line 2008: pay_balance_pkg.get_value(p_assignment_action_id => p_run_assignment_action_id,

2004: allow_context_table(1).tax_unit_id := g_tax_unit_id;
2005:
2006: if (p_run_assignment_action_id is NOT NULL)
2007: then
2008: pay_balance_pkg.get_value(p_assignment_action_id => p_run_assignment_action_id,
2009: p_defined_balance_lst=>allow_balance_value_tab,
2010: p_context_lst =>allow_context_table,
2011: p_output_table=>allow_result_table);
2012: