1070: CURSOR validate_org(c_org_id NUMBER)
1071: IS
1072:
1073: /* Perf. fix for bug# 4949394. Replace ORG_ORGANIZATION_DEFINITIONS
1074: with INV_ORGANIZATION_NAME_V.
1075: SELECT a.organization_id,
1076: b.eam_enabled_flag
1077: FROM ORG_ORGANIZATION_DEFINITIONS a,MTL_PARAMETERS b
1078: WHERE a.organization_id=b.organization_id
1080: */
1081:
1082: SELECT a.organization_id,
1083: b.eam_enabled_flag
1084: FROM INV_ORGANIZATION_NAME_V a,MTL_PARAMETERS b
1085: WHERE a.organization_id=b.organization_id
1086: AND a.organization_id=c_org_id;
1087:
1088: l_org_rec validate_org%ROWTYPE;