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_RECON_SUMMARY dependencies on PAY_AU_PAYMENT_SUMMARY

Line 205: Very similar to pay_au_payment_summary.adjust_retro_allowances excpet for an individual assignment

201:
202: /**************
203: bug 7571001 : new function - adjust_retro_group_allowances
204: This is called from get_total_allowances function for group level calculation to adjust allowance
205: Very similar to pay_au_payment_summary.adjust_retro_allowances excpet for an individual assignment
206: **************/
207:
208: function adjust_retro_group_allowances(t_allowance_balance IN OUT NOCOPY pay_au_payment_summary.t_allowance_balance%type
209: ,p_year_start in DATE

Line 208: function adjust_retro_group_allowances(t_allowance_balance IN OUT NOCOPY pay_au_payment_summary.t_allowance_balance%type

204: This is called from get_total_allowances function for group level calculation to adjust allowance
205: Very similar to pay_au_payment_summary.adjust_retro_allowances excpet for an individual assignment
206: **************/
207:
208: function adjust_retro_group_allowances(t_allowance_balance IN OUT NOCOPY pay_au_payment_summary.t_allowance_balance%type
209: ,p_year_start in DATE
210: ,p_year_end in DATE
211: ,p_registered_employer in NUMBER --2610141
212: )

Line 215: /* This cursor is similar to Get_retro_Entry_ids cursor in pay_au_payment_summary.adjust_retro_allowances

211: ,p_registered_employer in NUMBER --2610141
212: )
213: return number is
214:
215: /* This cursor is similar to Get_retro_Entry_ids cursor in pay_au_payment_summary.adjust_retro_allowances
216: except paa.assignment_id = c_assignment_id
217: */
218: /* Bug: 12400821 - Performance Improvement done */
219: CURSOR Get_retro_Entry_ids(c_year_start DATE,

Line 479: then pay_au_payment_summary.adjust_retro_allowances is called for 'N' dimension level or

475:
476: /***************
477: bug 7571001 - get_total_allowances function is entirely changed to enable group level reporting
478: pay_balance_pkg.get_value is called with different input values based on g_bal_dim_level
479: then pay_au_payment_summary.adjust_retro_allowances is called for 'N' dimension level or
480: adjust_retro_group_allowances is called for 'G'.
481: ***************/
482: Function get_total_allowances ( p_year_start DATE,
483: p_year_end DATE,

Line 496: t_allowance_balance pay_au_payment_summary.t_allowance_balance%type;

492: where pdb.defined_balance_id = p_def_bal_id
493: and pdb.balance_type_id = pbt.balance_type_id
494: ;
495:
496: t_allowance_balance pay_au_payment_summary.t_allowance_balance%type;
497: l_balance_name pay_balance_types.balance_name%type;
498: cnt number := 1;
499: counter number := 1;
500: i number;

Line 548: i := pay_au_payment_summary.adjust_retro_allowances

544: END LOOP;
545:
546: IF t_allowance_balance.count >0 THEN
547:
548: i := pay_au_payment_summary.adjust_retro_allowances
549: (t_allowance_balance
550: ,p_year_start
551: ,p_year_end
552: ,p_assignment_id

Line 1003: /bug8711855 - p_assignment_action_id parameter is added to call pay_au_payment_summary.get_retro_lumpsumE_value function /

999: return l_lump_sum_d;
1000:
1001: end Total_Lump_Sum_D_Payments;
1002:
1003: /*bug8711855 - p_assignment_action_id parameter is added to call pay_au_payment_summary.get_retro_lumpsumE_value function */
1004: function Total_Lump_Sum_E_Payments(c_year_end DATE,
1005: c_assignment_id pay_assignment_actions.assignment_id%type,
1006: c_registered_employer NUMBER) --2610141
1007: return number is

Line 1062: g_lump_sum_e := pay_au_payment_summary.get_lumpsumE_value(c_registered_employer, c_assignment_id, c_year_start,

1058: /* bug8711855 - To adjust Lump Sum E with single lump sum e payments less than 400*/
1059: /* Bug 9190980 - Added argument in call to get_lumpsumE_value function */
1060: if g_lump_sum_e <> 0 then
1061:
1062: g_lump_sum_e := pay_au_payment_summary.get_lumpsumE_value(c_registered_employer, c_assignment_id, c_year_start,
1063: c_year_end, p_lump_sum_E_ptd_tab, g_lump_sum_e, v_adj_lump_sum_E_ptd,v_adj_lump_sum_pre_tax); -- Bug 9190980
1064:
1065: end if;
1066:

Line 1784: p_fw_allowance_tab pay_au_payment_summary.t_allowance_balance%type;

1780: l_fw_union_asg_le_ytd number;
1781: l_alw_total number;
1782: g_fw_check varchar2(1);
1783: l_fbt_total number;
1784: p_fw_allowance_tab pay_au_payment_summary.t_allowance_balance%type;
1785: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
1786: counter number;
1787: l_fw_cdep_asg_le_ytd number;
1788: cnt number;

Line 1998: pay_au_payment_summary.get_foreign_leave_payments

1994:
1995: IF (get_bal_value_new(g_db_id_flp) - g_fw_result_table(28).balance_value) <> 0
1996: THEN
1997:
1998: pay_au_payment_summary.get_foreign_leave_payments
1999: (c_assignment_id
2000: ,p_tax_unit_id
2001: ,c_year_start
2002: ,c_year_end

Line 2037: n := pay_au_payment_summary.adjust_retro_fw(c_assignment_id

2033: /* start bug 9950136 */
2034: l_retro_fw_gross := 0;
2035: l_retro_fw_tax := 0;
2036: IF t_fw_gross_type(i_idx) = 'F' THEN
2037: n := pay_au_payment_summary.adjust_retro_fw(c_assignment_id
2038: ,p_tax_unit_id
2039: ,c_year_start
2040: ,c_year_end
2041: ,pay_au_foreign_workers.g_fw_f_type

Line 2045: n := pay_au_payment_summary.adjust_retro_fw(c_assignment_id

2041: ,pay_au_foreign_workers.g_fw_f_type
2042: ,l_retro_fw_gross
2043: ,l_retro_fw_tax);
2044: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
2045: n := pay_au_payment_summary.adjust_retro_fw(c_assignment_id
2046: ,p_tax_unit_id
2047: ,c_year_start
2048: ,c_year_end
2049: ,pay_au_foreign_workers.g_fw_j_type

Line 2128: x := pay_au_payment_summary.adjust_retro_allowances

2124: if p_fw_allowance_tab.count >0 then
2125:
2126: IF t_fw_gross_type(i_idx) = 'F' THEN
2127: for i in f_fw_date_tab_g.FIRST .. f_fw_date_tab_g.LAST loop
2128: x := pay_au_payment_summary.adjust_retro_allowances
2129: (p_fw_allowance_tab
2130: ,f_fw_date_tab_g(i).start_date
2131: ,f_fw_date_tab_g(i).end_date
2132: ,c_assignment_id

Line 2138: x := pay_au_payment_summary.adjust_retro_allowances

2134: );
2135: end loop;
2136: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
2137: for i in j_fw_date_tab_g.FIRST ..j_fw_date_tab_g.LAST loop
2138: x := pay_au_payment_summary.adjust_retro_allowances
2139: (p_fw_allowance_tab
2140: ,j_fw_date_tab_g(i).start_date
2141: ,j_fw_date_tab_g(i).end_date
2142: ,c_assignment_id