DBA Data[Home] [Help]

APPS.CZ_CF_API dependencies on CZ_EXV_ORGANIZATIONS

Line 4013: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

4009: IF (NVL(p_org_id,'') = '') OR (NVL(p_inventory_item_id,'')= '') THEN
4010: RAISE INVALID_OPTION_EXCEPTION ;
4011: END IF;
4012:
4013: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
4014: WHERE ORGANIZATION_CODE = p_org_id;
4015:
4016: OPEN C_GETMODELS(nOrg_ID);
4017: LOOP

Line 4115: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

4111: IF (NVL(p_org_id,'') = '') OR (NVL(p_inventory_item_id,'')= '') THEN
4112: RAISE INVALID_OPTION_EXCEPTION ;
4113: END IF;
4114:
4115: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
4116: WHERE ORGANIZATION_CODE = p_org_id;
4117:
4118: OPEN C_GETMODELS(nOrg_ID);
4119: LOOP