DBA Data[Home] [Help]

APPS.HREMPTER dependencies on PER_TIME_PERIODS

Line 1074: FROM per_time_periods ptp,

1070: -- nonrecurring element entry
1071: CURSOR period_end (p_asg_id in NUMBER,
1072: p_start_date in DATE) IS
1073: SELECT ptp.end_date
1074: FROM per_time_periods ptp,
1075: per_all_assignments_f paaf
1076: WHERE paaf.assignment_id = p_asg_id
1077: AND p_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1078: AND paaf.payroll_id = ptp.payroll_id