DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on JTF_RS_DEFRESOURCES_VL

Line 13750: FROM JTF_RS_DEFRESROLES_VL role, JTF_RS_DEFRESOURCES_VL res

13746:
13747:
13748: Cursor C_role (X_Resource_Id NUMBER, X_Profile_Role_Type VARCHAR2) IS
13749: SELECT role.role_type_code, role.manager_flag
13750: FROM JTF_RS_DEFRESROLES_VL role, JTF_RS_DEFRESOURCES_VL res
13751: WHERE role.role_resource_id = res.resource_id
13752: AND res.resource_id = X_resource_id
13753: AND nvl(trunc(role.res_rl_start_date), trunc(sysdate)) <= trunc(sysdate)
13754: AND nvl(trunc(role.res_rl_end_date), trunc(sysdate)) >= trunc(sysdate)