APPS.PAY_IE_PRSI dependencies on PAY_ALL_PAYROLLS_F

Line 193: from pay_all_payrolls_f pap

189: l_period_type varchar2(120);
190: --
191: cursor get_type is
192: select pap.period_type
193: from pay_all_payrolls_f pap
194: where pap.payroll_id = p_payroll_id
195: and p_session_date between pap.effective_start_date and pap.effective_end_date;
196: --
197: Begin