DBA Data[Home] [Help]

APPS.GMD_FORMULA_ANALYSIS dependencies on ORG_ACCESS_VIEW

Line 425: FROM org_access_view

421: FROM fm_form_mst
422: WHERE formula_id = V_formula_id;
423: CURSOR get_orgn_code IS
424: SELECT organization_code
425: FROM org_access_view
426: WHERE organization_id = p_organization_id;
427:
428: X_formula_id NUMBER;
429: X_formula_no VARCHAR2(32);

Line 1191: FROM org_access_view o, gmd_parameters_hdr p

1187: l_orgn_code VARCHAR2(3);
1188:
1189: CURSOR Cur_check_orgn IS
1190: SELECT 1
1191: FROM org_access_view o, gmd_parameters_hdr p
1192: WHERE o.organization_id = p_organization_id
1193: AND o.organization_id = p.organization_id
1194: AND p.lab_ind = 1;
1195:

Line 1212: FROM org_access_view

1208: AND inventory_item_id = p_ing_rec.item_id;
1209:
1210: CURSOR get_orgn_code IS
1211: SELECT organization_code
1212: FROM org_access_view
1213: WHERE organization_id = p_organization_id;
1214: BAD_DENSITY EXCEPTION;
1215: BEGIN
1216: x_return_status := 'S';