APPS.LNS_LOAN_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 483: FROM jtf_rs_resource_extns res

479: ELSE
480: BEGIN
481: SELECT 'Y'
482: INTO l_dummy
483: FROM jtf_rs_resource_extns res
484: WHERE res.resource_id = P_Loan_Details_Rec.loan_assigned_to
485: AND res.category = 'EMPLOYEE'
486: AND res.start_date_active <= SYSDATE
487: AND (res.end_date_active is null or res.end_date_active >= SYSDATE);