398: Cursor csr_pd_dates (p_end_date DATE, p_payroll_id NUMBER)
399: IS
400: select *
401: from
402: per_time_periods
403: where
404: payroll_id = p_payroll_id
405: and p_end_date between START_DATE AND END_DATE;
406:
742: ,pay_payrolls_f ppf
743: ,hr_soft_coding_keyflex scl
744: ,pay_assignment_actions paa
745: ,pay_payroll_actions ppa
746: ,per_time_periods ptp --8848543
747: WHERE paaf.person_id BETWEEN p_start_person AND p_end_person
748: AND papf.PERSON_ID = paaf.PERSON_ID
749: AND ppf.payroll_id = nvl(p_payroll_id,ppf.payroll_id)
750: AND paaf.payroll_id = ppf.payroll_id
1122: Cursor csr_pd_dts (p_end_date DATE, p_payroll_id NUMBER)
1123: IS
1124: select *
1125: from
1126: per_time_periods
1127: where
1128: payroll_id = p_payroll_id
1129: and p_end_date between START_DATE AND END_DATE;
1130: