APPS.PV_PARTNER_ACCESSES_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 993: -- check, the supplied resource in the JTF_RS_RESOURCE_EXTNS table is ACTIVE and EXISTS.

989: FROM pv_partner_profiles
990: WHERE partner_id = cv_partner_id
991: AND status = 'A';
992:
993: -- check, the supplied resource in the JTF_RS_RESOURCE_EXTNS table is ACTIVE and EXISTS.
994: CURSOR l_chk_resource_active_csr(cv_resource_id IN NUMBER) IS
995: SELECT 'Y'
996: FROM jtf_rs_resource_extns
997: WHERE resource_id = cv_resource_id

Line 996: FROM jtf_rs_resource_extns

992:
993: -- check, the supplied resource in the JTF_RS_RESOURCE_EXTNS table is ACTIVE and EXISTS.
994: CURSOR l_chk_resource_active_csr(cv_resource_id IN NUMBER) IS
995: SELECT 'Y'
996: FROM jtf_rs_resource_extns
997: WHERE resource_id = cv_resource_id
998: AND nvl(end_date_active , sysdate) >= sysdate;
999:
1000: -- Local variale declaration.