DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on PER_ASSIGNMENTS_F

Line 537: FROM pay_payrolls_f pp, per_assignments_f pa

533: -- Cursor to see if payroll exists for an assignment.
534: CURSOR csr_pay_freq (p_assignment_id NUMBER,
535: p_effective_date DATE) IS
536: SELECT pp.period_type
537: FROM pay_payrolls_f pp, per_assignments_f pa
538: WHERE pa.assignment_id = p_assignment_id
539: AND p_effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
540: AND pp.payroll_id = pa.payroll_id
541: AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;