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_SA_GOSI_REPORTS dependencies on PAY_RUN_RESULTS

Line 1810: ,pay_run_results rr1

1806: ,ff_contexts ct2
1807: ,pay_action_contexts ac3
1808: ,ff_contexts ct3
1809: ,pay_payroll_actions ppa
1810: ,pay_run_results rr1
1811: ,pay_run_results rr2
1812: ,pay_run_results rr3
1813: WHERE ppa.business_group_id = p_business_group_id
1814: AND ppa.action_type IN ('R','Q')

Line 1811: ,pay_run_results rr2

1807: ,pay_action_contexts ac3
1808: ,ff_contexts ct3
1809: ,pay_payroll_actions ppa
1810: ,pay_run_results rr1
1811: ,pay_run_results rr2
1812: ,pay_run_results rr3
1813: WHERE ppa.business_group_id = p_business_group_id
1814: AND ppa.action_type IN ('R','Q')
1815: AND ppa.action_status = 'C'

Line 1812: ,pay_run_results rr3

1808: ,ff_contexts ct3
1809: ,pay_payroll_actions ppa
1810: ,pay_run_results rr1
1811: ,pay_run_results rr2
1812: ,pay_run_results rr3
1813: WHERE ppa.business_group_id = p_business_group_id
1814: AND ppa.action_type IN ('R','Q')
1815: AND ppa.action_status = 'C'
1816: AND ppa.date_earned BETWEEN TRUNC(l_prev_mon_date,'MM')

Line 1936: ,pay_run_results rr1

1932: ,ff_contexts ct2
1933: ,pay_action_contexts ac3
1934: ,ff_contexts ct3
1935: ,pay_payroll_actions ppa
1936: ,pay_run_results rr1
1937: ,pay_run_results rr2
1938: ,pay_run_results rr3
1939: WHERE ppa.business_group_id = p_business_group_id
1940: AND ppa.action_type IN ('R','Q')

Line 1937: ,pay_run_results rr2

1933: ,pay_action_contexts ac3
1934: ,ff_contexts ct3
1935: ,pay_payroll_actions ppa
1936: ,pay_run_results rr1
1937: ,pay_run_results rr2
1938: ,pay_run_results rr3
1939: WHERE ppa.business_group_id = p_business_group_id
1940: AND ppa.action_type IN ('R','Q')
1941: AND ppa.action_status = 'C'

Line 1938: ,pay_run_results rr3

1934: ,ff_contexts ct3
1935: ,pay_payroll_actions ppa
1936: ,pay_run_results rr1
1937: ,pay_run_results rr2
1938: ,pay_run_results rr3
1939: WHERE ppa.business_group_id = p_business_group_id
1940: AND ppa.action_type IN ('R','Q')
1941: AND ppa.action_status = 'C'
1942: AND ppa.date_earned BETWEEN TRUNC(l_effective_date,'MM')

Line 1982: ,pay_run_results prr

1978: ,per_all_assignments_f paf
1979: ,per_periods_of_service pps
1980: ,hr_soft_coding_keyflex hscl
1981: ,per_time_periods ptp
1982: ,pay_run_results prr
1983: where paf.period_of_service_id = pps.period_of_service_id
1984: and nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'))
1985: between trunc(l_effective_date,'MM') and trunc(l_eff_term_date-1)
1986: /*****between trunc(l_effective_date,'MM') and trunc(l_eff_term_date-1)********* CHECK THIS*/

Line 2010: ,pay_run_results prr

2006: ,per_all_assignments_f paf
2007: ,per_periods_of_service pps
2008: ,hr_soft_coding_keyflex hscl
2009: ,per_time_periods ptp
2010: ,pay_run_results prr
2011: where paf.period_of_service_id = pps.period_of_service_id
2012: and nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'))
2013: between l_prev_term_date and trunc(l_eff_term_date-1)
2014: and paf.assignment_id = paa.assignment_id

Line 2038: ,pay_run_results prr

2034: ,per_all_assignments_f paf
2035: ,per_periods_of_service pps
2036: ,hr_soft_coding_keyflex hscl
2037: ,per_time_periods ptp
2038: ,pay_run_results prr
2039: where paf.period_of_service_id = pps.period_of_service_id
2040: and nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'))
2041: not between trunc(l_effective_date,'MM') and trunc(l_eff_term_date-1)
2042: and trunc(pps.date_start, 'MM') = trunc(l_effective_date,'MM')