APPS.LNS_LOAN_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 604: FROM jtf_rs_resource_extns res

600: ELSE
601: BEGIN
602: SELECT 'Y'
603: INTO l_dummy
604: FROM jtf_rs_resource_extns res
605: WHERE res.resource_id = P_Loan_Details_Rec.loan_assigned_to
606: AND res.category = 'EMPLOYEE'
607: AND res.start_date_active <= SYSDATE
608: AND (res.end_date_active is null or res.end_date_active >= SYSDATE);