DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on PER_TIME_PERIODS

Line 402: per_time_periods

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:

Line 746: ,per_time_periods ptp --8848543

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

Line 1126: per_time_periods

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: