DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PER_TIME_PERIODS

Line 299: FROM per_time_periods ptp

295: ,cp_effective_date DATE
296: )
297: IS
298: SELECT ptp.start_date,ptp.end_date
299: FROM per_time_periods ptp
300: WHERE (ptp.end_date > ( SELECT MAX(effective_date)
301: FROM pay_payroll_actions ppa
302: ,pay_assignment_actions paa
303: WHERE ppa.action_status='C'

Line 323: FROM per_time_periods ptp

319: ,cp_effective_date DATE
320: )
321: IS
322: SELECT ptp.start_date,ptp.end_date
323: FROM per_time_periods ptp
324: WHERE ptp.end_date >= cp_effective_date
325: AND ptp.payroll_id=cp_payroll_id
326: AND ROWNUM=1 ;
327: