DBA Data[Home] [Help]

APPS.GMD_RESULTS_PUB dependencies on ORG_ACCESS_VIEW

Line 135: FROM gmd_parameters_hdr gmd, org_access_view org

131: WHERE application_short_name = 'GMD';
132:
133: CURSOR check_resp_lab_access(cp_lab_organization_id NUMBER,cp_application_id NUMBER) IS
134: SELECT 1
135: FROM gmd_parameters_hdr gmd, org_access_view org
136: WHERE org.organization_id = gmd.organization_id
137: AND org.organization_id = cp_lab_organization_id
138: AND org.responsibility_id = p_user_responsibility_id
139: AND org.resp_application_id = cp_application_id