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);