DBA Data[Home] [Help]

APPS.PAY_IPD_BUS dependencies on PER_ASSIGNMENTS_F

Line 708: FROM pay_payrolls_f pp, per_assignments_f pa

704: ) IS
705: -- Select Payroll Frequency
706: CURSOR csr_pay_freq IS
707: SELECT pp.period_type
708: FROM pay_payrolls_f pp, per_assignments_f pa
709: WHERE pa.assignment_id = p_assignment_id
710: AND p_effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
711: AND pp.payroll_id = pa.payroll_id
712: AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;