DBA Data[Home] [Help]

APPS.PAY_ES_BAL_UPLOAD dependencies on PAY_ALL_PAYROLLS_F

Line 95: ,pay_all_payrolls_f ppf

91: CURSOR csr_payroll_start_date (p_assignment_id NUMBER
92: ,p_upload_date DATE) IS
93: SELECT nvl(ppf.effective_start_date, end_of_time)
94: FROM per_all_assignments_f ass
95: ,pay_all_payrolls_f ppf
96: WHERE ass.assignment_id = p_assignment_id
97: AND p_upload_date BETWEEN
98: nvl(ass.effective_start_date,p_upload_date) AND
99: nvl(ass.effective_end_date,p_upload_date)