DBA Data[Home] [Help]

APPS.PAY_P45_PKG2 dependencies on PER_TIME_PERIODS

Line 613: from per_time_periods ptp1,

609: -- Called by HREMEA library.
610: --
611: cursor get_reg_pay_date_period is
612: select ptp2.end_date regular_payment_end_date
613: from per_time_periods ptp1,
614: per_time_periods ptp2
615: where p_act_term_date between ptp1.start_date and ptp1.end_date
616: and ptp1.payroll_id IN (select pa.payroll_id
617: from per_assignments pa

Line 614: per_time_periods ptp2

610: --
611: cursor get_reg_pay_date_period is
612: select ptp2.end_date regular_payment_end_date
613: from per_time_periods ptp1,
614: per_time_periods ptp2
615: where p_act_term_date between ptp1.start_date and ptp1.end_date
616: and ptp1.payroll_id IN (select pa.payroll_id
617: from per_assignments pa
618: where pa.period_of_Service_id = p_period_of_service_id