DBA Data[Home] [Help]

APPS.GHR_PER_SUM dependencies on PER_TIME_PERIODS

Line 796: from per_time_periods ptp

792: RETURN DATE IS
793:
794: CURSOR cur_payroll_start IS
795: select start_date
796: from per_time_periods ptp
797: where payroll_id in (select payroll_id
798: from per_assignments_f
799: where assignment_id = p_assignment_id
800: and trunc(p_effective_date) between effective_start_date