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 PER_ASSIGNMENTS_F

Line 387: /* Bug: 3603495 - Performance Fix - Introduced per_assignments_f and its joins in the following cursor */

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'
390: Bug: 4256506 - Changed cursor c_max_asg_action_id. Merged sub query to fetch max action sequemce in main query. Done for
391: better performance.

Line 401: , per_assignments_f paf

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
404: and ppa.payroll_action_id = paa.payroll_action_id
405: and ppa.effective_date between c_year_start and c_year_end

Line 597: /* Bug No:3603495 - Performance Fix - In the following cursor, introduced table per_assignments_f and its joins */

593: AND pbt.balance_type_id = pdb.balance_type_id
594: AND pbd.balance_dimension_id = pdb.balance_dimension_id
595: AND pbd.dimension_name = '_ASG_LE_PTD';
596:
597: /* Bug No:3603495 - Performance Fix - In the following cursor, introduced table per_assignments_f and its joins */
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:

Line 607: from per_assignments_f paf,

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*/
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

Line 1711: l_asgid per_assignments_f.assignment_id%type;

1707: p_end_person_id in per_all_people_f.person_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;

Line 1768: INDEX(paa per_assignments_f_N12)

1764: )
1765: is
1766: SELECT /*+ INDEX(pap per_people_f_pk)
1767: INDEX(rppa pay_payroll_actions_pk)
1768: INDEX(paa per_assignments_f_N12)
1769: INDEX(pps per_periods_of_service_pk)
1770: */ paa.assignment_id
1771: from per_people_f pap
1772: ,per_assignments_f paa

Line 1772: ,per_assignments_f paa

1768: INDEX(paa per_assignments_f_N12)
1769: INDEX(pps per_periods_of_service_pk)
1770: */ paa.assignment_id
1771: from per_people_f pap
1772: ,per_assignments_f paa
1773: ,pay_payroll_actions rppa
1774: ,per_periods_of_service pps
1775: where rppa.payroll_action_id = p_payroll_action_id
1776: and pap.person_id between p_start_person_id and p_end_person_id

Line 1786: FROM per_assignments_f iipaf

1782: and nvl(pps.actual_termination_date, p_lst_year_start) >= p_lst_year_start
1783: and p_fin_year_end between pap.effective_start_date and pap.effective_end_date
1784: /* Start of Bug: 3872211 */
1785: and paa.effective_end_date = (SELECT MAX(effective_end_date) /*4377367*/
1786: FROM per_assignments_f iipaf
1787: WHERE iipaf.assignment_id = paa.assignment_id
1788: AND iipaf.effective_end_date >= p_fbt_year_start
1789: AND iipaf.effective_start_date <= p_fin_year_end
1790: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */

Line 1800: ,per_assignments_f paaf -- Bug: 3872211

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

Line 1846: INDEX(paa per_assignments_f_N12)

1842: IS
1843: SELECT /*+ INDEX(pap per_people_f_pk)
1844: INDEX(rppa pay_payroll_actions_pk)
1845: INDEX(ppr PAY_POPULATION_RANGES_N4)
1846: INDEX(paa per_assignments_f_N12)
1847: INDEX(pps per_periods_of_service_PK)
1848: */ paa.assignment_id
1849: from per_people_f pap
1850: ,per_assignments_f paa

Line 1850: ,per_assignments_f paa

1846: INDEX(paa per_assignments_f_N12)
1847: INDEX(pps per_periods_of_service_PK)
1848: */ paa.assignment_id
1849: from per_people_f pap
1850: ,per_assignments_f paa
1851: ,pay_payroll_actions rppa
1852: ,per_periods_of_service pps
1853: ,pay_population_ranges ppr
1854: where rppa.payroll_action_id = p_payroll_action_id

Line 1867: FROM per_assignments_f iipaf

1863: and nvl(pps.actual_termination_date, p_lst_year_start) >= p_lst_year_start
1864: and p_fin_year_end between pap.effective_start_date and pap.effective_end_date
1865: /* Start of Bug: 3872211 */
1866: and paa.effective_end_date = (SELECT MAX(effective_end_date) /*4377367*/
1867: FROM per_assignments_f iipaf
1868: WHERE iipaf.assignment_id = paa.assignment_id
1869: AND iipaf.effective_end_date >= p_fbt_year_start
1870: AND iipaf.effective_start_date <= p_fin_year_end
1871: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */

Line 1881: ,per_assignments_f paaf -- Bug: 3872211

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

Line 1915: INDEX(paa per_assignments_f_fk1)

1911: p_lst_year_start date
1912: )
1913: is
1914: SELECT /*+ INDEX(pap per_people_f_pk)
1915: INDEX(paa per_assignments_f_fk1)
1916: INDEX(paa per_assignments_f_N12)
1917: INDEX(rppa pay_payroll_actions_pk)
1918: INDEX(pps per_periods_of_service_n3)
1919: */ distinct paa.assignment_id

Line 1916: INDEX(paa per_assignments_f_N12)

1912: )
1913: is
1914: SELECT /*+ INDEX(pap per_people_f_pk)
1915: INDEX(paa per_assignments_f_fk1)
1916: INDEX(paa per_assignments_f_N12)
1917: INDEX(rppa pay_payroll_actions_pk)
1918: INDEX(pps per_periods_of_service_n3)
1919: */ distinct paa.assignment_id
1920: from per_people_f pap

Line 1921: ,per_assignments_f paa

1917: INDEX(rppa pay_payroll_actions_pk)
1918: INDEX(pps per_periods_of_service_n3)
1919: */ distinct paa.assignment_id
1920: from per_people_f pap
1921: ,per_assignments_f paa
1922: ,pay_payroll_actions rppa
1923: ,per_periods_of_service pps
1924: where rppa.payroll_action_id = p_payroll_action_id
1925: and pap.person_id between p_start_person_id and p_end_person_id

Line 1936: From per_assignments_f iipaf

1932: and nvl(pps.actual_termination_date, p_lst_year_start) >= p_lst_year_start
1933: and p_fin_year_end between pap.effective_start_date and pap.effective_end_date
1934: -- and least(nvl(pps.actual_termination_date,p_fin_year_end),p_fin_year_end) between paa.effective_start_date and paa.effective_end_date
1935: and paa.effective_end_date = (select max(effective_end_date) /*4377367*/
1936: From per_assignments_f iipaf
1937: WHERE iipaf.assignment_id = paa.assignment_id
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 */

Line 1949: ,per_assignments_f paaf -- Bug: 3872211

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