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_ASSIGNMENT_ACTIONS

Line 157: c_assignment_id pay_assignment_actions.assignment_id%type,

153:
154:
155: Function get_total_allowances(c_year_start DATE,
156: c_year_end DATE,
157: c_assignment_id pay_assignment_actions.assignment_id%type,
158: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
159: c_registered_employer NUMBER,
160: c_message OUT NOCOPY VARCHAR2) --2610141
161: return number is

Line 158: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

154:
155: Function get_total_allowances(c_year_start DATE,
156: c_year_end DATE,
157: c_assignment_id pay_assignment_actions.assignment_id%type,
158: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
159: c_registered_employer NUMBER,
160: c_message OUT NOCOPY VARCHAR2) --2610141
161: return number is
162:

Line 170: c_assignment_id pay_assignment_actions.assignment_id%type)

166: employees and also improve the performance of the query.*/
167:
168: /* CURSOR Get_Allowance_Balances(c_year_start DATE,
169: c_year_end DATE,
170: c_assignment_id pay_assignment_actions.assignment_id%type)
171:
172: IS
173:
174: select balance_name,

Line 189: ,pay_assignment_actions pac

185: ,pay_defined_balances pdb
186: ,pay_balance_dimensions pbd
187: -- ,per_periods_of_service pps
188: ,pay_payroll_actions ppa
189: ,pay_assignment_actions pac
190: ,pay_run_results prr
191: WHERE pac.assignment_id = c_assignment_id
192: AND pac.tax_unit_id = c_registered_employer --2610141
193: AND paa.assignment_id = pac.assignment_id

Line 221: (c_assignment_id pay_assignment_actions.assignment_id%type

217: /*Bug#4863149 - Introduced a new cursor to get all the allowance balance type id's*/
218: /* Bug 7138494 - Changed rom Date Earned to Effective date for better
219: performance - Added ORDERED HINT */
220: cursor get_allowance_balance_types
221: (c_assignment_id pay_assignment_actions.assignment_id%type
222: ,c_start_date date
223: ,c_end_date date
224: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
225: IS

Line 224: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)

220: cursor get_allowance_balance_types
221: (c_assignment_id pay_assignment_actions.assignment_id%type
222: ,c_start_date date
223: ,c_end_date date
224: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
225: IS
226: SELECT /*+ ORDERED */
227: DISTINCT pet.element_information2 balance_type_id
228: FROM per_all_assignments_f paf

Line 230: ,pay_assignment_actions paa

226: SELECT /*+ ORDERED */
227: DISTINCT pet.element_information2 balance_type_id
228: FROM per_all_assignments_f paf
229: ,pay_payroll_actions ppa
230: ,pay_assignment_actions paa
231: ,pay_run_results prr
232: ,pay_element_types_f pet
233: WHERE paa.assignment_id = c_assignment_id
234: AND paf.business_group_id = ppa.business_group_id

Line 373: c_assignment_id pay_assignment_actions.assignment_id%type,

369:
370:
371:
372: Function get_total_fbt(c_year_start DATE,
373: c_assignment_id pay_assignment_actions.assignment_id%type,
374: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
375: c_fbt_rate ff_globals_f.global_value%TYPE,
376: c_ml_rate ff_globals_f.global_value%TYPE,
377: p_termination VARCHAR2)

Line 385: l_max_asg_action_id pay_assignment_actions.assignment_action_id%type;

381: l_reporting_amt number;
382: l_fbt_rate number;
383: l_medicare_levy number;
384: l_fbt_ratio number;
385: l_max_asg_action_id pay_assignment_actions.assignment_action_id%type;
386:
387: /* Bug: 3603495 - Performance Fix - Introduced per_assignments_f and its joins in the following cursor */
388: /* Bug: 4015571 - Modified cursor c_max_asg_action_id - Modified action_type join in sub query
389: to restrict the max action_sequence fetch to types 'Q','R','B','I'

Line 399: from pay_assignment_actions paa

395: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,
396: c_year_start date,
397: c_year_end date ) is
398: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
399: from pay_assignment_actions paa
400: , pay_payroll_actions ppa
401: , per_assignments_f paf
402: where paa.assignment_id = paf.assignment_id
403: and paf.assignment_id = c_assignment_id

Line 574: c_assignment_id pay_assignment_actions.assignment_id%type,

570: end Total_Lump_Sum_D_Payments;
571:
572:
573: function Total_Lump_Sum_E_Payments(c_year_end DATE,
574: c_assignment_id pay_assignment_actions.assignment_id%type,
575: c_registered_employer NUMBER) --2610141
576: return number is
577: v_lump_sum_E_ptd number;
578: v_effective_date date; /* Bug#3095923 */

Line 583: v_assignment_id pay_assignment_actions.assignment_id%type,

579: c_year_start date;
580: l_assignment_action_id number; --2610141
581:
582: CURSOR c_single_lumpsum_E_payment(v_effective_date DATE,
583: v_assignment_id pay_assignment_actions.assignment_id%type,
584: v_assignment_action_id pay_assignment_actions.assignment_id%type) --2610141
585:
586: IS
587: select pay_balance_pkg.get_value(pdb.defined_balance_id, v_assignment_action_id, c_registered_employer,null,null,null,null) --2610141

Line 584: v_assignment_action_id pay_assignment_actions.assignment_id%type) --2610141

580: l_assignment_action_id number; --2610141
581:
582: CURSOR c_single_lumpsum_E_payment(v_effective_date DATE,
583: v_assignment_id pay_assignment_actions.assignment_id%type,
584: v_assignment_action_id pay_assignment_actions.assignment_id%type) --2610141
585:
586: IS
587: select pay_balance_pkg.get_value(pdb.defined_balance_id, v_assignment_action_id, c_registered_employer,null,null,null,null) --2610141
588: FROM pay_balance_types pbt,

Line 602: CURSOR c_get_pay_effective_date(v_assignment_id pay_assignment_actions.assignment_id%type

598: /*Bug 4363057 - Cursor has been modified so that the Lum Sum E Payments given to previous legal employers
599: can be taken into account while calculating payment summary gross.*/
600:
601:
602: CURSOR c_get_pay_effective_date(v_assignment_id pay_assignment_actions.assignment_id%type
603: ,v_year_start in DATE
604: ,v_year_end in DATE)
605: IS
606: select max(paa.assignment_action_id) /* Bug#3095923 , Bug 2610141*/

Line 609: pay_assignment_Actions paa,

605: IS
606: select max(paa.assignment_action_id) /* Bug#3095923 , Bug 2610141*/
607: from per_assignments_f paf,
608: pay_payroll_Actions ppa,
609: pay_assignment_Actions paa,
610: per_time_periods ptp
611: where ppa.payroll_Action_id = paa.payroll_Action_id
612: and paa.assignment_id = v_assignment_id
613: and paf.assignment_id = paa.assignment_id

Line 879: p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

875: END populate_bal_ids;
876:
877: function etp_details
878: (
879: p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
880: ,p_year_start in pay_payroll_Actions.effective_date%type
881: ,p_year_end in pay_payroll_Actions.effective_date%type)
882: return number is
883:

Line 903: CURSOR etp_code(c_assignment_id in pay_assignment_actions.assignment_id%type,

899: l_death_benefit_type varchar2(100);
900: l_lst_yr_start date;
901:
902:
903: CURSOR etp_code(c_assignment_id in pay_assignment_actions.assignment_id%type,
904: c_lst_year_start in pay_payroll_actions.effective_date%type,
905: c_year_start in pay_payroll_actions.effective_date%type,
906: c_year_end in pay_payroll_actions.effective_date%type
907: )is

Line 1074: c_assignment_id pay_assignment_actions.assignment_id%type,

1070:
1071:
1072: PROCEDURE get_value_bbr(c_year_start DATE,
1073: c_year_end DATE,
1074: c_assignment_id pay_assignment_actions.assignment_id%type,
1075: c_fbt_rate ff_globals_f.global_value%TYPE,
1076: c_ml_rate ff_globals_f.global_value%TYPE,
1077: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1078: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

Line 1077: p_assignment_action_id pay_assignment_actions.assignment_id%type,

1073: c_year_end DATE,
1074: c_assignment_id pay_assignment_actions.assignment_id%type,
1075: c_fbt_rate ff_globals_f.global_value%TYPE,
1076: c_ml_rate ff_globals_f.global_value%TYPE,
1077: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1078: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
1079: p_termination_date DATE, --Bug 3098367
1080: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367
1081: p_output_tab OUT NOCOPY bal_tab,

Line 1218: pay_assignment_actions paat,

1214: c_financial_year varchar2)
1215: is
1216: SELECT distinct paat.assignment_id
1217: from pay_action_interlocks pail,
1218: pay_assignment_actions paat,
1219: pay_payroll_actions paas
1220: where paat.assignment_id = c_assignment_id
1221: and paas.action_type ='X'
1222: and paas.action_status ='C'

Line 1403: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL

1399:
1400: END populate_group_def_bal_ids;
1401:
1402: PROCEDURE get_group_values_bbr
1403: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
1404: , p_date_earned IN date
1405: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
1406: , p_group_output_tab OUT NOCOPY bal_tab ) IS
1407:

Line 1405: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

1401:
1402: PROCEDURE get_group_values_bbr
1403: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
1404: , p_date_earned IN date
1405: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
1406: , p_group_output_tab OUT NOCOPY bal_tab ) IS
1407:
1408: BEGIN
1409: bal_id.delete;

Line 1456: , p_assignment_id IN pay_assignment_actions.assignment_id%type

1452:
1453: PROCEDURE get_assgt_curr_term_values_bbr
1454: ( p_year_start IN date
1455: , p_year_end IN date
1456: , p_assignment_id IN pay_assignment_actions.assignment_id%type
1457: , p_fbt_rate IN ff_globals_f.global_value%TYPE
1458: , p_ml_rate IN ff_globals_f.global_value%TYPE
1459: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
1460: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE

Line 1459: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type

1455: , p_year_end IN date
1456: , p_assignment_id IN pay_assignment_actions.assignment_id%type
1457: , p_fbt_rate IN ff_globals_f.global_value%TYPE
1458: , p_ml_rate IN ff_globals_f.global_value%TYPE
1459: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
1460: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
1461: , p_emp_type IN varchar2
1462: , p_term_output_tab OUT NOCOPY bal_tab
1463: , p_message OUT NOCOPY VARCHAR2) IS

Line 1701: -- It inserts the record in pay_assignment_Actions

1697:
1698: --------------------------------------------------------------------
1699: -- This procedure further restricts the assignment_id's
1700: -- returned by range_code
1701: -- It inserts the record in pay_assignment_Actions
1702: -- Which are then used in main report query to get assignment_ids
1703: --------------------------------------------------------------------
1704: procedure assignment_action_code
1705: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 1712: l_next_action_id pay_assignment_actions.assignment_action_id%type;

1708: p_chunk in number) is
1709:
1710:
1711: l_asgid per_assignments_f.assignment_id%type;
1712: l_next_action_id pay_assignment_actions.assignment_action_id%type;
1713:
1714:
1715: l_lst_yr_start date;
1716: l_lst_fbt_yr_start date;

Line 1750: select pay_assignment_actions_s.nextval

1746: from pay_payroll_actions
1747: where payroll_action_id =c_payroll_Action_id;
1748:
1749: cursor next_action_id is
1750: select pay_assignment_actions_s.nextval
1751: from dual;
1752:
1753: cursor c_asgids(p_assignment_id varchar2,
1754: p_business_group_id hr_organization_units.organization_id%type,

Line 1793: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

1789: AND iipaf.effective_start_date <= p_fin_year_end
1790: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
1791: and paa.payroll_id like p_payroll_id
1792: /* End of Bug: 3872211 */
1793: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1794: INDEX(rpac pay_assignment_actions_n1)
1795: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1796: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1797: FROM

Line 1794: INDEX(rpac pay_assignment_actions_n1)

1790: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
1791: and paa.payroll_id like p_payroll_id
1792: /* End of Bug: 3872211 */
1793: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1794: INDEX(rpac pay_assignment_actions_n1)
1795: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1796: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1797: FROM
1798: pay_payroll_actions rppa

Line 1799: ,pay_assignment_actions rpac

1795: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1796: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1797: FROM
1798: pay_payroll_actions rppa
1799: ,pay_assignment_actions rpac
1800: ,per_assignments_f paaf -- Bug: 3872211
1801: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1802: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
1803: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end

Line 1874: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

1870: AND iipaf.effective_start_date <= p_fin_year_end
1871: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
1872: and paa.payroll_id like p_payroll_id
1873: /* End of Bug: 3872211 */
1874: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1875: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1876: INDEX(rppa PAY_PAYROLL_ACTIONS_PK)
1877: */''
1878: FROM

Line 1880: ,pay_assignment_actions rpac

1876: INDEX(rppa PAY_PAYROLL_ACTIONS_PK)
1877: */''
1878: FROM
1879: pay_payroll_actions rppa
1880: ,pay_assignment_actions rpac
1881: ,per_assignments_f paaf -- Bug: 3872211
1882: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1883: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
1884: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end

Line 1942: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

1938: and iipaf.effective_end_date >= p_fbt_year_start
1939: and iipaf.effective_start_date <= p_fin_year_end
1940: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
1941: and paa.payroll_id like p_payroll_id
1942: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1943: INDEX(rpac pay_assignment_actions_n1)
1944: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1945: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1946: FROM

Line 1943: INDEX(rpac pay_assignment_actions_n1)

1939: and iipaf.effective_start_date <= p_fin_year_end
1940: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
1941: and paa.payroll_id like p_payroll_id
1942: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1943: INDEX(rpac pay_assignment_actions_n1)
1944: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1945: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1946: FROM
1947: pay_payroll_actions rppa

Line 1948: ,pay_assignment_actions rpac

1944: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1945: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1946: FROM
1947: pay_payroll_actions rppa
1948: ,pay_assignment_actions rpac
1949: ,per_assignments_f paaf -- Bug: 3872211
1950: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1951: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
1952: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end

Line 2184: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

2180: -- internally calls private procedures to archive balances ,
2181: -- employee details, employer details and supplier details .
2182: --------------------------------------------------------------------
2183: procedure archive_code
2184: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2185: p_effective_date in date)is
2186: begin
2187: NULL;
2188: END;