DBA Data[Home] [Help]

APPS.PAY_SA_GOSI_REPORTS dependencies on PER_TIME_PERIODS

Line 1981: ,per_time_periods ptp

1977: ,pay_payroll_actions ppa
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)

Line 2009: ,per_time_periods ptp

2005: ,pay_payroll_actions ppa
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)

Line 2037: ,per_time_periods ptp

2033: ,pay_payroll_actions ppa
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)