DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PER_TIME_PERIODS

Line 824: ,per_time_periods ptp

820: SELECT /*+ leading(paa) */
821: DISTINCT ptp.start_date start_date, ptp.end_date end_date
822: FROM pay_assignment_actions paa
823: ,pay_payroll_actions ppa
824: ,per_time_periods ptp
825: WHERE ptp.time_period_id = ppa.time_period_id
826: AND ppa.payroll_action_id = paa.payroll_action_id
827: AND ppa.effective_date BETWEEN p_effective_start_date AND p_effective_end_date
828: AND ppa.action_type IN('R', 'Q', 'I', 'V', 'B')