DBA Data[Home] [Help]

APPS.HREMPTER dependencies on PER_TIME_PERIODS

Line 1092: FROM per_time_periods ptp,

1088: -- nonrecurring element entry
1089: CURSOR period_end (p_asg_id in NUMBER,
1090: p_start_date in DATE) IS
1091: SELECT ptp.end_date
1092: FROM per_time_periods ptp,
1093: per_all_assignments_f paaf
1094: WHERE paaf.assignment_id = p_asg_id
1095: AND p_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1096: AND paaf.payroll_id = ptp.payroll_id