[Home] [Help]
1144: and el.effective_end_date >= p_validation_start_date;
1145:
1146: cursor csr_chk_position is
1147: select 'found'
1148: from hr_all_positions_f po
1149: where po.pay_freq_payroll_id = p_payroll_id
1150: and po.effective_start_date <= p_validation_end_date
1151: and po.effective_end_date >= p_validation_start_date;
1152: