DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_ALL_PAYROLLS_F

Line 1137: pay_all_payrolls_f papf

1133: CURSOR csr_payroll_period(csr_v_payroll_id number, csr_v_start_date DATE, csr_v_end_date DATE)
1134: IS
1135: SELECT papf.period_type, min(ptp.start_date),min(ptp.end_date)
1136: FROM per_time_periods ptp,
1137: pay_all_payrolls_f papf
1138: WHERE ptp.payroll_id=csr_v_payroll_id --4337 --3469
1139: AND ptp.payroll_id=papf.payroll_id
1140: AND /*'15-jan-2005'*/ ptp.START_DATE >=csr_v_start_date
1141: AND ptp.end_date <=csr_v_end_date