DBA Data[Home] [Help]

APPS.GMD_RESULTS_PUB dependencies on ORG_ACCESS_VIEW

Line 183: FROM gmd_parameters_hdr gmd, org_access_view org

179: WHERE application_short_name = 'GMD';
180:
181: CURSOR check_resp_lab_access(cp_lab_organization_id NUMBER,cp_application_id NUMBER) IS
182: SELECT 1
183: FROM gmd_parameters_hdr gmd, org_access_view org
184: WHERE org.organization_id = gmd.organization_id
185: AND org.organization_id = cp_lab_organization_id
186: AND org.responsibility_id = p_user_responsibility_id
187: AND org.resp_application_id = cp_application_id