DBA Data[Home] [Help]

APPS.ASO_SECURITY_INT dependencies on JTF_RS_RESOURCE_EXTNS

Line 982: FROM jtf_rs_resource_extns

978: L_API_NAME VARCHAR2(50) := 'Add_SalesRep_QuoteCreator';
979:
980: CURSOR C_user_resource_id (l_user_id NUMBER) IS
981: SELECT resource_id
982: FROM jtf_rs_resource_extns
983: WHERE user_id = l_user_id
984: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
985:
986: CURSOR C_get_resource_role ( l_resource_id NUMBER) IS