DBA Data[Home] [Help]

APPS.PAY_IN_TERMINATION_PKG dependencies on PER_TIME_PERIODS

Line 445: per_time_periods ptp,

441: ppa.effective_date,
442: ptp.start_date,
443: ptp.end_date
444: FROM
445: per_time_periods ptp,
446: pay_payroll_actions ppa,
447: pay_assignment_actions paa
448: WHERE ptp.payroll_id = p_payroll_id
449: AND ptp.start_date between TRUNC(p_start_date,'MM') AND p_end_date

Line 465: per_time_periods ptp,

461: ppa.effective_date,
462: ptp.start_date,
463: ptp.end_date
464: FROM
465: per_time_periods ptp,
466: pay_payroll_actions ppa,
467: pay_assignment_actions paa
468: WHERE ptp.payroll_id = p_payroll_id
469: AND ptp.payroll_id = ppa.payroll_id