APPS.PAY_IE_TAX_VAL dependencies on PER_ASSIGNMENTS_F

Line 352: FROM pay_payrolls_f pp, per_assignments_f pa

348: -- Cursor to see if payroll exists for an assignment.
349: CURSOR csr_pay_freq (p_assignment_id NUMBER,
350: p_effective_date DATE) IS
351: SELECT pp.period_type
352: FROM pay_payrolls_f pp, per_assignments_f pa
353: WHERE pa.assignment_id = p_assignment_id
354: AND p_effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
355: AND pp.payroll_id = pa.payroll_id
356: AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;

Line 3505: FROM pay_payrolls_f pp, per_assignments_f pa

3501: -- Cursor to see if payroll exists for an assignment.
3502: CURSOR csr_pay_freq (p_assignment_id NUMBER,
3503: p_effective_date DATE) IS
3504: SELECT pp.period_type
3505: FROM pay_payrolls_f pp, per_assignments_f pa
3506: WHERE pa.assignment_id = p_assignment_id
3507: AND p_effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
3508: AND pp.payroll_id = pa.payroll_id
3509: AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;